Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: how to store +/- 500char text in db

    what is the best way for me to store approx 500chars of text in my table? text / varchar / blob / other? Can anyone explain the differences / benefits?

  2. #2
    Join Date
    Jun 2004

    If you want to store more than 255 characters of text in MySQL table, you should use the TEXT column type. CHAR and VARCHAR don't match your needs because both of them allow to store strings with max. lenght <= 255. The BLOB type is almost the same as TEXT, but it is generally used for storing binary data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts