Hi Igor,
>The blob (x'41' is a blob literal) is expected to contain a UTF-8 >sequence, I believe. That means the user enters the hex UTF-8 (or 16 depending on base encoding) representation of the character. E.g.: select cast(x'c389' as text); É Something like: select chrw(x'c9'); or select chrw(201); would be much more convenient and not depend on base encoding IMHO. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users