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 m
>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" o
Hi,
I have a small patch for the SQLite Shell 3.9.2, it convert sql command text to
utf-8 before sending to SQLite engine,
And convert the result text back to default code page after sqlite3_exec.
Before patch( SQLite shell in windows 10 Chinese version):
SQLite version 3.9.2 2015-11-02 18:31:4
>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
On 12/30/15, Quan Yong Zhai wrote:
> Hi,
> I have a small patch for the SQLite Shell 3.9.2, it convert sql command text
> to utf-8 before sending to SQLite engine,
Please send a unified diff, generated using the -u option to the
"diff" command. Even better would be the "-U 8" option, to include
5 matches
Mail list logo