Hi Roger Thanks a lot for such a quick reply...
On Sun, Sep 27, 2009 at 3:18 PM, Roger Binns <[email protected]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Sean Moss-Pultz wrote: >> How can I get the string to stay 0123? > > It isn't a string - you supplied an integer and SQLite treated it that way > and then stored it. If you really wanted a string then you must quote it > (remember to use single quotes). If you are using the C api then you can > use bindings and bind exactly as the type you want. OK. Then I'm going to need to escape this string since the insert is really coming from a import of a huge datadump generated in Python. str.encode("string-escape") would be the best method right? Is that aways safe for any string? My data set is quite large with all kinds of mixtures of strings. I'm encoding everything to UTF-8 first. Then writing out a sql dump file to import. -Sean _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
