Re: [sqlite] UTF-8 and ISO-8859-1 in the same library

2004-07-30 Thread Christian Smith
On Fri, 30 Jul 2004, Bertrand Mansion wrote: >Hi, > >How difficult would it be to have both UTF-8 and ISO-8859-1 supported in >the same library (2.8.15) ? By looking quickly at the sources, it seems >to be just a matter of changing the functions likeFunc(), globFunc(), >lengthFunc() and

[sqlite] HOWTO: Adding Natural Sort To Sqlite Database...

2004-07-30 Thread tezozomoc
HOWTO: Adding Natural Sort To Sqlite Database... Assumption... this is based on SQLITE 2.8.6... forgive the aging.. I will make this very short and sweet... 1. Get the following two files: a.. strnatcmp.c, strnatcmp.h - the algorithm itself from a..

Re: [sqlite] Versions 2.8.15 and 3.0.3 available

2004-07-30 Thread sankara . narayanan
Return Receipt Your Re: [sqlite] Versions 2.8.15 and 3.0.3 available document :

RE: [sqlite] Wildcards in LIKE

2004-07-30 Thread Dennis Volodomanov
Ok, just found it - sorry... But this does raise a question, I have UNICODE data, but it says that LIKE only works correctly (i.e. case-insensitive) on 7-bit data. Can someone tell me please how to make it work correctly for UNICODE as well then? As I read from the docs there, I have to override