Is it true that VARCHAR
type in mysql only suppory 255 characters data length?
if it is开发者_开发问答 true what kind of datatype for UTF8 strings is useful for long texts? I'm using utf8_persian_ci
datatype.
Note that TEXT datatype have problem with utf8_persian_ci
.
Is it true that VARCHAR type in mysql only suppory 255 characters data length?
Not since MySQL 5.0.3, according to the documentation:
The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions.
The max length of a VARCHAR
in all current versions of MySQL is 65535.
In old releases of MySQL, VARCHAR
had a max length of 255, but that's ancient history (where ancient is prior to March 2005).
The CHAR
data type still has a limit of 255 characters.
When I need to store large amounts of text, I go for a TEXT field with the utf8_general_ci collation. To be honest, I am not sure what the difference between the different uft8 encodings are, but if you need to store longer texts, go for one of the TEXT types.
you may use "utf8_general_ci collation" I think this will help you, but m not sure
精彩评论