Subject: | Not respecting text fields |
Using syntax that works in DBD::MySQL and DBD::PostgreSQL, I attempt to
insert values into a varchar(10) field. But if the value is one that
*could* be interpreted at a number, it is interpreted as a number first,
and then inserted into the varchar(10) field. For instance
$id = '0E9';
$wptInsertStmt = $conn->prepare(qq{
INSERT INTO waypoint (id) values(?)});
$wptInsertStmt->execute($id);
is ending up with "0" in the database instead of "0E9".
(DBD::SQLite 1.11 and perl v5.8.4 installed from Debian Sarge repository)