> I had issues in my SQLite DB schema - VARCHAR(64) was not big enough. Just a note: SQLite doesn't impose any limits on text columns. So for SQLite VARCHAR(64) is the same type as VARCHAR(1234567), and both types can accept strings of any length. Apparently your .NET library parsed declared type of the column and enforced the length you mentioned.
Pavel On Tue, Mar 30, 2010 at 5:23 PM, Burnett, Joe <[email protected]> wrote: > Thank you all for the replies. The message was a bit of a red herring. > I had issues in my SQLite DB schema - VARCHAR(64) was not big enough. > > Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL > TECHNOLOGY > 2 Contra Way > Merrimack, NH 03054 > 603.791.5113 > cell: 603.289.0481 > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Tim Romano > Sent: Tuesday, March 30, 2010 5:20 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Select * from tablename results in an exception > > http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/27aec61 > 2-5ca4-41ba-80d6-0204893fdcd1 > > Maybe related. > Regards > Tim Romano > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
