Hi all,
sorry for the delay. But finally I got an installation of DBD::SQLite.
The result of my tests made me happy: all data types I like to use are accepted
and handled correct. Additionally types DBD::CSV does not allow in a CREATE
TABLE, like BOOLEAN, DATETIME and CLOB, and the constraint DEFAULT, are
available within DBD::SQLite.
:-)
Greetings
Robert
-----------
Owen schrieb:
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
