On Wed, 27 May 2009 16:19:28 +0200 Robert Roggenbuck <rrogg...@uni-osnabrueck.de> wrote:
> Hi all, > > while looking at the SQLite-Documentation at http://www.sqlite.org I > detected that there are only a few SQL data types supported, namely > INTEGER, REAL and CLOB. Additionally there is the non-standard type > TEXT. I wonder how DBD::SQLite treats CREATE TABLE statements > containing CHARACTER, VARCHAR, BOOLEAN, DATE, TIME and other useful > data types. Using DBD::CSV most of them are "accepted" but not > treated special. Is it necessary to reformulate my CREATE TABLE > statements if I decide to use DBD::SQLite? I use DBD::SQLite all the time, but never had to reuse another script. I would simply try it on a sample file. Hopefully it will silently ignore those assignments. perldoc DBD::SQLite and DBI are worth the read if you haven't done so. Owen
