Sergei, thank you for clarifying this. I was misinterpreting the manual where it says:
`FULLTEXT' indexes can be created from `VARCHAR' and `TEXT' columns at `CREATE TABLE' time ... Regards, Thomas Spahni On Wed, 13 Mar 2002, Sergei Golubchik wrote: > Hi! > > On Mar 13, Thomas Spahni wrote: > > On Tue, 12 Mar 2002, shaj wrote: > > > > > Can any one tell me what is the text limitation for mySQL?? > > > > TEXT datatype is limited to a maximum length of 65535 (2^16 - 1) > > characters. > > > > LONGTEXT allows up to 4'294'967'295 (2^32 - 1) characters, which is enuf > > for most applications. The real limitation is that fulltext indexing only > > works for VARCHAR and TEXT. > > > > Thomas > > What do you mean ? > It works for all *TEXT types, from TINYTEXT and up to LONGTEXT. > And for VARCHAR, yes. > > Regards, > Sergei --------------------------------------------------------------------- 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
