Re: [sqlite] Custom Collation comparing only firt character?

Jean-Denis MUYS wrote: > int collationAnyCIAI(void *arg1, int str1Length, const void *str1, int > str2Length, const void *str2) { > > But maybe you have good reasons to ignore the Apple-provided collations. In > that case, I still don't get why you don't work > directly on

Re: [sqlite] Custom Collation comparing only firt character?

>Cool - can you please post a link to the sources? Sure, here you are: http://dl.dropbox.com/u/26433628/unifuzz.zip The .c source contains all details (and all the bugs). -- j...@antichoc.net ___ sqlite-users mailing list

Re: [sqlite] Custom Collation comparing only firt character?

On Sat, Aug 27, 2011 at 12:04 AM, Jean-Christophe Deschamps < j...@antichoc.net> wrote: > If you also need to search names with uncertain spelling, you can also > use my typos() function to perform a fuzzy search. Here's a sample of > its use on a decently populated ZipCodes table (848207 rows):

Re: [sqlite] Custom Collation comparing only firt character?

Roberto, >Though I cannot use DLLs since it is an iPhone iOS (MacOSX) >operational system. I made it DLL by default at build time since it fits my needs. You can still compile the extension (or part of it) as a standard .o obj and statically link it into your application. >I was hoping for

Re: [sqlite] Custom Collation comparing only firt character?

Roberto Colnaghi wrote: > Thank you for your detailed reply. > Though I cannot use DLLs since it is an iPhone iOS (MacOSX) operational > system.I was hoping for a collation callback that is > called for all characters, not only the first. It is. What do you think str1Length

Re: [sqlite] Custom Collation comparing only firt character?

11 13:30:57 +0200 To: colna...@msn.com From: j...@antichoc.net Subject: Re: [sqlite] Custom Collation comparing only firt character? Hi Roberto, It all depends on your data source(s). If you're sure you have all accented codepoints dealt whith in your custom collation, then it may be enough. But i

Re: [sqlite] Custom Collation comparing only firt character?

On 25 Aug 2011, at 6:58am, Roberto Colnaghi wrote: > int collationAnyCIAI(void *arg1, int str1Length, const void *str1, int > str2Length, const void *str2) { > NSString *strA = [NSString hexStringWithData:str1 ofLength:1]; > NSString *strB = [NSString hexStringWithData:str2

Re: [sqlite] Custom Collation comparing only firt character?

-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roberto Colnaghi Sent: Thursday, August 25, 2011 1:59 AM To: sqlite-users@sqlite.org Subject: [sqlite] Custom Collation comparing only firt character? Hi, I'm using iOS SQLite with a custom collation. I've

Re: [sqlite] Custom Collation comparing only firt character?

Roberto Colnaghi wrote: > It works though only the FIRST character seems to be compared instead of the > whole "Name". > Is there anything missing here? > > int collationAnyCIAI(void *arg1, int str1Length, const void *str1, int > str2Length, const void *str2) { > NSString

[sqlite] Custom Collation comparing only firt character?

Hi, I'm using iOS SQLite with a custom collation. I've registered it: sqlite3_create_collation(sqlDatabase, "anyCIAI", SQLITE_UTF16, nil,