-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Victoria, et al --
...and then Victoria Reznichenko said... % % On Monday 20 January 2003 16:16, David T-G wrote: % > create table pieces % > ( ... % > words text (4095) , % > fulltext index (words(4095)) % > ) ; % % David, "words text (4095)" is incorrect definition of column. TEXT is a % variable-length column type with the maximum size 64K: % http://www.mysql.com/doc/en/Storage_requirements.html Ahhh... I get it. I took from the docs that you could specify how much you wanted to assign for a TEXT. I know that I won't need the full 64k for the text of the piece, though tinytext is too small, and so I wanted to save space that I knew would be wasted. Thanks for the pointer! % % You should use % [skip] % ... % words TEXT, % FULLTEXT(words) And because it's fulltext rather than just index I don't have to specify the length of what I want to index, right? Thanks & HAND mysql query :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+LTn2Gb7uCXufRwARAhweAKDJUay4sCeepIqR7UfB833HO8JvXACgxw+i lzW/PZ1lbq2qimebhG8wK0I= =A6JK -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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