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

    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
    Posts
    12
    Hi,

    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
  •