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: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 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 <joe.burn...@fmr.com> 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: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
