Row sizes in MySQL tables can't exceed 65535 bytes (BLOB and, presumably,
TEXT fields are not counted towards this total). That means you can't
defined a table where the *possible* size of a row might be larger than
that -- e.g. a column of type VARCHAR(255) gets counted as taking up 256
bytes towards that total, even though most of the time it will be much
smaller.
I had tried creating a table with a lot of fields, then ran into problems
because of the size limit, so I changed some of the field types from text
to integer (which they should have been to begin with, but I was just using
a script to create the table quickly so I hadn't bothered with that
tweak). Now I'm under the 65535-character limit, but I don't know how
close I am. Is there a way to determine the size (or rather, the maximum
possible size) of a row in a given table?
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org
(425) 649 9024
---------------------------------------------------------------------
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
