Hi Pavel, Thank you for the background information. It helps me understand what I observed.
Thanks again, Joe 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 Pavel Ivanov Sent: Wednesday, March 31, 2010 11:30 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Select * from tablename results in an exception > 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
