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
Post a Comment