MySQL

[Richard Dice]

Hi Jason,


> When creating a table in MySQL varchar supports a length of up to 255
> characters. Does anybody know what I use if I want to support say 10000 or
> even higher?
>

This is going to depend somewhat on what version of MySQL you are using.
Newer versions allow you to specify varchar up to varchar(65535).  For
example, see http://dev.mysql.com/doc/refman/5.1/en/char.html

If you need more than that, consider using the 'text' data type.
http://dev.mysql.com/doc/refman/5.1/en/blob.html
Before you use text data types you should read up on the various differences
between it and varchar in terms of text encoding, padding, indexing, storage
and efficiency.  It's all mentioned in the online manual, but you need to
look around in a few places for it.

Cheers,
 - Richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/legacy/attachments/20090720/64866f7d/attachment.html>