-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 13/05/12 08:07, Frank Chang wrote: > Good Morning, Is it possible to determine the length of UNICODE(UTF-8 > or UTF-16) strings stored in SQLite 3.7.11 database?
http://www.sqlite.org/fileformat.html You should be accessing things via SQL and the C API. In that case the encoding in the database is not relevant as the strings have their encoding converted as appropriate. sqlite3_column_bytes and sqlite3_column_bytes16 tell you the length of the utf8/16 string in bytes while sqlite3_column_text and sqlite3_column_text16 get you the utf8/16 data. http://www.sqlite.org/c3ref/column_blob.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk+v2AYACgkQmOOfHg372QR68ACcDqmI5pAncgUCs2MAu0trFmVS arwAn3/jR4XBktvKe+PtJQhWnje6aHbL =N6o7 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
