-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Guenther Schmidt wrote: > when I use inserts through prepared statements on windows with ODBC > all text field values are messed up.
Either the values you supply to the ODBC driver, or the ODBC driver itself is at fault (most likely the former). (SQLite fundamentally does work correctly with all the documented types including strings.) Start with http://article.gmane.org/gmane.comp.db.sqlite.general/41828 You can try simple tests such as executing these queries and seeing what you get back: SELECT 3 SELECT 'abc' SELECT 'abcæ' SELECT 'abcædef' SELECT 'ரறல' Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkj8ApQACgkQmOOfHg372QS+NACdE0eIDqUUm67KZ/0nxYhEEOSe oz0AnAz5/0pdlcA8kc5AEoOfUNrxx0M8 =lxAN -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
