>> >> inserting the following into my virtual table: >> >> >> >> 一日耶羅波安出 >> >> Can you post the list of codepoints in this text? Or the hex >> of the utf-16 or utf-8 encoding of the same?
00 4E E5 65 36 80 85 7F E2 6C 89 5B FA 51 Here no problem inserting this string (Mac OSX 10.6.8) sqlite> create table u8_t (u8c1 varchar(32)); sqlite> insert into u8_t values ('一日耶羅波安出'); sqlite> .mode list sqlite> select * from u8_t; u8c1 一日耶羅波安出 sqlite> .quit [[bash SQLite]] sqlite Club.sl3 SQLite version 3.7.13 2012-06-11 02:05:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> Cordiali saluti/Vriendelijke groeten/Kind regards, Klaas V http://innocentisart.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users