-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 07/09/2010 09:30 AM, Jay A. Kreibich wrote:
> They can't be stored as text values without some type of encoding
> (like base64), but they can be stored as BLOBs.
Nulls can be stored in text values. Behind the scenes SQLite treats strings
and blobs almost identically and you'll notice most functions operate on
both. The major difference is that strings can be transformed into UTF-8 or
UTF-16 encoding. Other than that they are both a bucket of bytes.
As an example look at the implementation of sqlite3_bind_{blob,text} or
trimFunc and replaceFunc.
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkw3WrsACgkQmOOfHg372QTzbACfVVfmAsmSBdvv6WwPtd00DzHt
/z4AoMORO0XCFsc3g3csCL6QA5meBzmM
=g/YJ
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
