-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Yang Zhang wrote: > I copied and pasted this code straight from my actual application, which > uses blobs instead of integers, which I need to convert into strings > (since Python interfaces with blobs using the `buffer` type, not `str`).
And for very good reason. Blobs are buckets of bytes and those are not strings. In your example there was no need to do the conversion since you can supply buffers as values too. (In Python 3 the bytes type is used.) Converting blobs to str is asking for future problems. For example SQLite does not verify that a string value is in fact legal UTF8. Other developers have played fast and loose ending up supplying a str when they really meant a buffer/blob which then ended up in the database as a string, but was invalid UTF8 when read back and causes an exception. I also strongly recommend reading this article: http://www.joelonsoftware.com/articles/Unicode.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoRoFUACgkQmOOfHg372QSIagCg5nllDS/Q5hsgfc+WzjS94Ubk 5jAAoONyqlKsczc1f+q01JqR6/Ysih2q =TODs -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
