Hick Gunter wrote:
> I was under the impression you wanted to achieve this:
>
> > select hex('abc' || X'10FFFD');
> 61626310FFFD
> > select length('abc' || X'10FFFD');
> 6
If you want to create characters through a blob, you have to use
the correct UTF-8 encoding:
sqlite> select quote(cast(char(1114109) as blob));
X'F48FBFBD'
sqlite> select unicode(x'F48FBFBD');
1114109
sqlite> select hex('abc' || x'F48FBFBD');
616263F48FBFBD
sqlite> select length('abc' || x'F48FBFBD');
4
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
