Loading

How to keep the column type without MySQL changing it?

Gordana Tasic

I have column "description" in table in MySQL database. Type for that column is longtext. However, when i want to write something in that column, MySQL changes type to varchar(255) and I have error "Data too long for column 'description' at row 1". Does anyone know how to keep type longtext without MySQL changing it?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
alter the table definition and retest
ALTER TABLE table_name MODIFY description LONGTEXT NOT NULL;