Re: stopping numification

[prev] [thread] [next] [Date index for 2005/05/25]

* Simon Wistow shaped the electrons to say...

>I don't even need the 
>
>	__PACKAGE__->__data_type({});
>	__PACKAGE__->data_type(version => DBI::SQL_BINARY);
>
>trick.
>
>So, yes. It does appear to be a DBD::SQLite problem - I was just getting 
>confused.

Try this patch, which puts the check back to how 1.07 did it:

diff -ru DBD-SQLite-1.08/dbdimp.c DBD-SQLite-1.08.fixed/dbdimp.c
--- DBD-SQLite-1.08/dbdimp.c	Tue Feb 22 08:09:23 2005
+++ DBD-SQLite-1.08.fixed/dbdimp.c	Mon Feb 28 23:23:59 2005
@@ -357,7 +357,7 @@
             char * data = SvPV(value, len);
             retval = sqlite3_bind_blob(imp_sth->stmt, i+1, data, len, SQLITE_TRANSIENT);
         }
-        else if (looks_like_number(value)) {
+        else if (SvNIOK(value)) {
             /* bind ordinary numbers as numbers - otherwise we might sort wrong */
             retval = sqlite3_bind_double(imp_sth->stmt, i+1, SvNV(value));
         }


-D
        -- 
        <weezyl> $6.66: The Value Meal of the Beast.