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