On Wed, May 14, 2014 at 8:30 AM, Hick Gunter <h...@scigames.at> wrote: > Actually SQLite does support X'xxxx...' literals for creating blobs.
Note sure how that's relevant Hick. We don't need a blob, but a integer for char(). I was obviously talking about *number* literals (prefixed with 0b, 0, 0x for binary / octal / hexa), not blob literals. I'd be +1 to having char() also accept blobs (1 to 3 bytes long) instead of integer, since x'10FFFD' is closer to U+10FFFD than 1114109 is. But Dr. Hipp would need to agree with that. Until then, 1114109 it must be. --DD C:\Users\DDevienne>sqlite3 SQLite version 3.8.4.3 2014-04-03 16:53:12 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> select char(x'10FFFD'); sqlite> select typeof(char(x'10FFFD')); text sqlite> select length(char(x'10FFFD')); 0 sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users