jack wu said: > i did not find the length limitations in the > documentation but seems like TEXT can only hold less > than 250 chars. is it true or is it SqliteExplorer > that only shows 250 chars. Thanks.
That's not a limitation of SQLite. I'm regularly storing strings larger than that in a TEXT field. Remember that the typing is only a suggestion in SQLite, and doesn't actually restrict the data stored. Clay -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development