-----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

Reply via email to