On Mon, Feb 8, 2016 at 6:26 PM, Dominique Devienne <ddevienne at gmail.com>
wrote:
> OK, I retried with latest sqlite3.exe, and the results are different:
>
> C:\Users\DDevienne>sqlite3
> SQLite version 3.10.2 2016-01-20 15:27:19
> Enter ".help" for usage hints.
> Connected to a transient in-memory database.
> Use ".open FILENAME" to reopen on a persistent database.
> sqlite> create table t? (c?);
> sqlite> insert into t? (c?) values (char(252));
> sqlite> insert into t? (c?) values ('?');
> sqlite> .header on
> sqlite> select c?, length(c?), length(cast(c? as blob)), unicode(c?),
> typeof(c?), quote(cast(c? as blob)) from t?;
> c?|length(c?)|length(cast(c? as
> blob))|unicode(c?)|typeof(c?)|quote(cast(c? as blob))
> ?|1|2|252|text|X'C3BC'
> ?|1|2|129|text|X'C281'
>
Latest unreleased 3.11 snapshot behaves the same:
D:\my\sqlite-snapshot>shell.exe
SQLite version 3.11.0 2016-02-09 02:12:20
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table t (c);
sqlite> insert into t values (char(252)), ('?');
sqlite> select c, length(c), length(cast(c as blob)), unicode(c),
typeof(c), quote(cast(c as blob)) from t;
?|1|2|252|text|X'C3BC'
?|1|2|129|text|X'C281'
