Search code examples
mysqltextclob

mysql : update table field type to Clob

i think that there is no type Clob in mysql. my question is: is this true? and if it is true(Clob doe'sn't exist in mysql) what type can i use for saving a very long text?

Solution

  • TEXT You can use TEXT OR BLOB datatype.

    BLOB or TEXT − A field with a maximum length of 65535 characters.
BLOBs are "Binary Large Objects" and are used to store large amounts of binary data, such as images or other types of files. 
Fields defined as TEXT also hold large amounts of data. 
The difference between the two is that the sorts and comparisons on the stored data are case sensitive on BLOBs and are not case sensitive in TEXT fields. 
You do not specify a length with BLOB or TEXT.