Thank you Richard.
The patch work very well
Here is a simple test:
E:\sqlite-src-3090200>chcp
?????: 936 ---active code page: 936
E:\sqlite-src-3090200>shell
SQLite version 3.9.2 2015-11-02 18:31:45
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(x,y);
sqlite> insert into t values('??','??');
sqlite> insert into t values('ABCEDFG','????');
sqlite> select length(x),length(y) from t;
2|2
7|4
sqlite> select substr(x,2,1), substr(y,3,1) from t;
?|
B|?
sqlite> select length('????');
4
sqlite> select substr('????',2,3);
???
sqlite> select instr('????','?');
4
From: Richard Hipp
Sent: 2015?12?30? 21:38
To: Quan Yong Zhai
Cc: SQLite mailing list
Subject: Re: [sqlite] A small patch for the SQLite shell in windows.
Please test the alternative patch found at
https://www.sqlite.org/src/info/a0a08b8c0bbd4d71 and let me know
whether or not the alternative patch fixes your problem.
On 12/30/15, Quan Yong Zhai <qydi at msn.com> wrote:
>>From: Richard Hipp
>>Sent: 2015?12?30? 20:21
>>To: SQLite mailing list
>>Subject: Re: [sqlite] A small patch for the SQLite shell in windows.
>
>>Please send a unified diff, generated using the -u option to the
>>"diff" command.? Even better would be the "-U 8" option, to include
>>more context.
>
> diff -U 8 src/shell.c /home/nana/shell.c
> ----------------diff.txt------cut here----------------------
--
D. Richard Hipp
drh at sqlite.org
