On 12/2/15, Erwin Kalvelagen <erwin at amsterdamoptimization.com> wrote: > Good morning. > > I wrote a little tool to dump certain data sets into a SQLite database. A > user suggested that I should not use type TEXT but rather type VARCHAR for > character columns, due to some issue with Excel/VBA. See the comments in: > http://yetanothermathprogrammingconsultant.blogspot.com/2013/10/gdx2sqlite.html > > > I could not find a reference to this using Google. So my question is: Is > this a known problem? I would like to understand a little bit better what > this is about. >
SQLite handles TEXT and VARCHAR equally well. There are no issues. Perhaps a 3rd-party GUI shell wrapper around SQLite is having problems with TEXT? -- D. Richard Hipp drh at sqlite.org
