5 ms·
> MySQL can't add TEXT type column without length specified Mysql does have a TEXT type with a max limit of 65536 chars (you can have MEDIUMTEXT or LONGTEXT if
by nickcw 7y ago
> MySQL can't add TEXT type column without length specified
Mysql does have a TEXT type with a max limit of 65536 chars (you can have MEDIUMTEXT or LONGTEXT if you want more).
You don't supply a length when you use TEXT
https://dev.mysql.com/doc/refman/8.0/en/blob.html https://dev.mysql.com/doc/refman/8.0/en/blob.html
- pizza234 7y agoTheir statement is somewhat ambiguous. They may have tried to express that "you can't add a column of the TEXT class without specifying the exact type". So they could be "right", but expressed the concept in an imprecise form. In a way, I think this shows their lack of expertise with MySQL - I reckon that somebody with a long experience would have phrased the concept more precisely.
- striking 7y agoIt doesn't matter, because they're looking for a different thing entirely. PostgreSQL TEXT is just without a limit. Simple as that.
- sbov 7y agoNot true, from: https://www.postgresql.org/docs/current/datatype-character.html https://www.postgresql.org/docs/current/datatype-character.h... > In any case, the longest possible character string that can be stored is about 1 GB.
- michelpp 7y agoTEXT, like all Postgres varlena types, is limited to 1GB. Which for many people is effectively without limit.