mysql BLOB and TEXT data type difference -


what's difference between blob , text data type in mysql ? ( except sortable )

blob used storing binary data, while text used store large strings.

as stated in mysql 5.1 reference manual:

blob values treated binary strings (byte strings). have no character set, , sorting , comparison based on numeric values of bytes in column values. text values treated nonbinary strings (character strings). have character set, , values sorted , compared based on collation of character set.


Comments