Migrating Varchar to Text in Mysql

mysql text varchar
ted picture ted · Jun 23, 2016 · Viewed 21.9k times · Source

I am converting one of the "Varchar" column in mysql table to a text field. I am simply using single alter command to convert the type. When i read about text and varchar came to know that it had difference in storing mechanisms.

Am I supposed to write any migration script to change the type of column and move data or a single type altering command is enough ?

Answer

Shusen Yi picture Shusen Yi · Sep 26, 2018 
ALTER TABLE table_name MODIFY column_name TEXT NOT NULL;

Related questions

MySQL: Large VARCHAR vs. TEXT?

I've got a messages table in MySQL which records messages between users. Apart from the typical ids and message types (all integer types) I need to save the actual message text as either VARCHAR or TEXT. I'm setting a front-end …

Read More
Difference between VARCHAR and TEXT in MySQL

When we create a table in MySQL with a VARCHAR column, we have to set the length for it. But for TEXT type we don't have to provide the length. What are the differences between VARCHAR and TEXT?

Read More
MySQL - TEXT vs CHAR and VARCHAR

Reading this question, a doubt popped into my head: char and varchar can store up to 255 chars text can store up to 65k chars char size in bytes is number of chars varchar size in bytes is number of chars …

Read More