John wrote:
A TEXT string is stored at its actual length. You may declare a text column as 80 characters wide but you could store a string 32K long in that column. The 80 is stored by Sqlite but ignored.
Stupid question. Does that mean that SQLite: * truncates the field at 80 characters? * only returns the first 80 characters in the field? * stores and returns the entire string? My impression was that it did that third option. [And that it didn't care what the data in that field was. It is up to the client program to verify the data.] xan jonathon ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------