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

[sqlite] skype artifacts and sqlite records.

2013-07-06 Thread Salvatore Fiorillo
Hi I am trying to write an open source tool to retieve bulk data from unallocated clusters.My focus is on Skype chats (artifacts) but could apply to others apps, too. This is where I am. By carving hard disks I can get chunk skype chats. >From each chat I can retrieve chatters' name, time of

[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>

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

2013-07-06 Thread Keith Medcalf
>Date: Fri, 05 Jul 2013 02:04:04 +0200 > >From: Olaf Schmidt >To: sqlite-users@sqlite.org >Subject: Re: [sqlite] Is there a way to return the row number? (NOT >therowid) >Message-ID: >Content-Type: text/plain; charset=ISO-8859-1;

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

2013-07-06 Thread j . merrill
Date: Fri, 05 Jul 2013 02:04:04 +0200 From: Olaf Schmidt To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a way to return the row number? (NOT the rowid) Message-ID: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Am

Re: [sqlite] SQLite3 extended API usage

2013-07-06 Thread Luuk
On 06-07-2013 09:50, techi eth wrote: Hi,When i try to use extended API like sqlite_get_table(), i am getting undefined reference to function. How do i get it resolve ? I am following below link for API reference. http://www.sqlite.org/c_interface.html That link leads to: The C language

[sqlite] SQLite3 extended API usage

2013-07-06 Thread techi eth
Hi,When i try to use extended API like sqlite_get_table(), i am getting undefined reference to function. How do i get it resolve ? I am following below link for API reference. http://www.sqlite.org/c_interface.html Bye - ___ sqlite-users mailing list