Hi,
On Tue, Feb 9, 2016 at 3:09 AM, Dominique Devienne <ddevienne at gmail.com>
wrote:
> 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'
I tried it (ALT+NUMPAD keys) and it works OK.
Thank you.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
