-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Scott Chapman wrote: > I take it that there's no way to work around this currently?
You can leave out the type for each column when declaring the table schema and no affinity conversions will happen. Alternatively, if you require that a type be declared then you can make up your own scheme that doesn't include any of the strings that SQLite picks up, somewhat similar to how C++ compilers do it: http://en.wikipedia.org/wiki/Name_mangling Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHqek7mOOfHg372QQRAm5XAJ0T2F/dA3TNEejFyFncfKAZkPIgywCglrG2 t0sPG/jg50Kevkb2eZQKUfs= =GlXb -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users