MySQL converting Text to Varchar

One incentive of converting a text column to a varchar column is that, you can index that column for quicker query.

Before converting, you want to make sure you won’t be truncating anything. Run the following to make sure

SELECT MAX( LENGTH(  target_column ) )
FROM  target_table

As long as the returned length is less than your varchar length, you are good to go.