At 22:47 +0200 9/23/02, David yahoo wrote:
Hi,
I have a column that can have 850 chars at max.
I think that I can only put this in a tinytext col type.
Probably not. The maximum size of TINYTEXT is 255 bytes. You need
at least a TEXT type. (MEDIUMTEXT and LONGTEXT will also work, but
are much longer than you need.)
How can I hav an index to this col mysql refuse me to add one ?
Depends on the table type. ISAM and InnoDB won't allow you to index
BLOB or TEXT columns. MyISAM and BDB do, but you must index just a
prefix of the column, up to a maximum of 255 characters.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php