I have a simple question and I am hoping that someone can help answer this question.

I have a very simple script that stores notes and text. Anyway, I am loading it into mysql and I was wondering what a better way to store data like notes, webmails and other large areas of text is???

Should I am storing it in a TEXT column or a BLOB in my MySql database?

Thanks for any help or ideas with this.

Jay

    Since it is textual data, TEXT would generally be best. (BLOB is designed to handle binary data.) From the manual:

    BLOB columns are treated as binary strings (byte strings). TEXT columns are treated as nonbinary strings (character strings). BLOB columns have no character set, and sorting and comparison are based on the numeric values of the bytes in column values. TEXT columns have a character set, and values are sorted and compared based on the collation of the character set.

      Thanks for the help. I thought that was the case, but I was not 100% on it so I thought I would ask. Thanks again for your help and suggestions.

        Thanks so much for your help and suggestions on this matter.

          Write a Reply...