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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users