It is a limitation of sqliteExplorer. > -----Original Message----- > From: jack wu [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 07, 2005 7:05 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] what is the difference between TEXT and > BLOB data type? > > > other than encoded and not encoded. > > 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. > > > >