if the data is not binary, you can use TEXT type - accepts all readable characters and data, BLOB type is more for binary data storage, and MYSQL's Varchar type only stores up to 255 characters. (65,536 bits, or 64Kbits)
If you are storing Binary data (DES-3 encrypted data, or image data, for example (a silly idea, IMHO, but some people store image data in databases), then you would use BLOB, but I prefer to use TEXT type for plain ol' storage of text or characters (say an html page or template, etc) rather than the binary BLOB type, although BLOB would be a space savings if the data will be quite large, and you will have many rows) HTH Bri! Kent Johnson wrote: > Adam Cripps wrote: > >>On 3/17/06, Kent Johnson <[EMAIL PROTECTED]> wrote: >> >>>Why are you using a BLOB when the content is text? >> >>I'm using BLOB because I want them to be able to write content that is >>longer than 255 chars. > > > I'm no MySQL expert but the docs say VARCHAR fields can be up to 65,535 > chars. > > Kent > > _______________________________________________ > Tutor maillist - Tutor@python.org > http://mail.python.org/mailman/listinfo/tutor > > !DSPAM:441acc98175353568816312! > > _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
