[ANN] PySQLite 0.4.0 released
gerhard.haering at gmx.de
Thu Feb 13 02:25:24 CET 2003
* Gerhard H?ring <gerhard.haering at gmx.de> [2003-02-11 14:06 +0000]:
> IMPORTANT BACKWARDS INCOMPATIBLE CHANGE:
> SQLite is typeless, that's why we had the special command
> "pysqlite_pragma expected types = type1, type2, ..., typen" which was parsed
> in the Python layer.
> Of course, this isn't standard SQL so such code isn't portable to other DB-API
> That's why I changed this mechanism. The new syntax is
> -- types = type1, type2, ..., typen
Sorry, typo here.
The syntax is really
-- types type1, ..., typen
*without* the '='. My new parser for the "-- types" at the C level hardly does
any error checking, so it will accept the first (wrong) form, but return None
for that column, because it cannot find any type converter for the "= type1"
More information about the Python-list