> > Simple illustration: > > > > sqlite3 test 'create table t ( k text unique, v text);' > > perl -e 'use DBI; $db = DBI->connect( "dbi:SQLite:dbname=test" ); > > $db->do( qq[REPLACE INTO t VALUES(?,?);], undef, "key", > > "0325763213");' > > sqlite3 test 'select * from t;' > > > > returns: > > > > key|325763213 > > > > > > It looks like perl is making this conversion for you. SQLite does > not do this. > > As a work-around, consider prepending a single 'x' character to every > "v" column entry then strip of the 'x' before you use it.
Knowing next to nothing about Perl, and thus feeling eminently qualified to comment on it, what would happen if you wrapped the number in single quotation marks instead of double ones, or put single ones inside the double ones, e.g. '0325763213' or "'0325763213'"?
