Simon Slavin <[email protected]> wrote: > On 21 Apr 2012, at 2:04am, Braddock Gaskill <[email protected]> wrote: > >> I now see that if I properly define the field type as VARCHAR instead of >> STRING that the CSV is correctly parsed. > > SQLite doesn't have either of those types. It's doing its best to guess what > you mean. Take a look at > > <http://www.sqlite.org/datatype3.html> > > The type you probably want is TEXT.
The rules are such that VARCHAR column also gets TEXT affinity. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
