Re: [sqlite] BUG REPORT: function instr() with chinese characters

2013-07-06 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/07/13 01:20, ?? wrote: > I am using the sqlite-shell-win32-x86-3071700, in WindowsXP SP3 I did the same queries on Linux and got very different answers that appear to be correct. I'd suggest using SQLite programmatically since the Windows c

[sqlite] BUG REPORT: function instr() with chinese characters

2013-07-06 Thread ??????
Hello, I am using the sqlite-shell-win32-x86-3071700, in WindowsXP SP3 The operation is like the following: .. F:\>sqlite3.exe 1.db SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table a (b int, c int); sqlite>