> The blob (x'41' is a blob literal) is expected to contain a UTF-8 sequence, I > believe.
I think it should be a database encoding which is either UTF-8 or UTF-16. So for Tim's case if his database encoding is UTF-16 insert statement can be like this: insert test (id, myTextColumn) values(1, x'01B50327') I'm not sure about byte order here but it can be easily determined with some tests. Pavel On Wed, Nov 18, 2009 at 11:13 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > Tim Romano <tim.rom...@yahoo.com> wrote: >> I wanted to get a clearer sense of how SQLite treats decomposed >> Unicode characters (http://unicode.org/faq/char_combmark.html#2) in >> its various string functions and with the concatenation operator yet >> there doesn't >> seem to be any way to get them into the database using the SQlite3.EXE >> command-line. > > select cast(x'41' as text); > A > > The blob (x'41' is a blob literal) is expected to contain a UTF-8 sequence, I > believe. > > Igor Tandetnik > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users