Re: newbie question on variable length records.

2001-05-01 Thread Rick Pasotto
I think he may be trying to put a variable number of *fields* in each record. This of course cannot be done directly. If that is what he wants he will need to have his own program merge/parse the data into a fixed number of MySQL fields (columns). On Tue, May 01, 2001 at 09:53:21AM -0400, Tim wro

Re: newbie question on variable length records.

2001-05-01 Thread Tim
This is straight from 7.7.1 of the MySQL manual: * If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three characters are changed to