So sprach »Nelson Goforth« am 2001-07-22 um 09:00:13 -0600 :
> According to _MySQL & mSQL_, by Yarger et al (O'Reilly) the TEXT
> datatype holds 64KB of data.
>
> Since my math skills and understanding of character storate are,
> well...wretched, someone should check me on this:
>
> 64KB = 64000 bytes = 64,000 characters (@ 1 character/byte),
K = 1024 in computing, not 1000
> (# bytes + 3) - while for TEXT it's (# bytes + 2). Therefore if your
> text field consisted of 8MB a MEDIUMTEXT field would be one byte
> longer than a TEXT version of the same field. And what is the
This may be true, if you disregard the fact that you cannot store 8 MB
in a TEXT field.
> benefit of TINYTEXT over a VARCHAR field?
This, I always wondered myself...
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 3 days 18 hours 30 minutes
---------------------------------------------------------------------
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
