Re: [sqlite] Question about searches

2009-06-17 Thread Olaf Schmidt
"Christophe Leske" schrieb im Newsbeitrag news:4a37b811.4030...@multimedial.de... >> You write your own comparison function that would consider >> these two strings equal. See sqlite3_create_function, >> sqlite3_create_collation. > > this problem pertains not only to Zürich, but to 24000 other >

Re: [sqlite] Question about searches

2009-06-16 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Machin wrote: > I have developed a table which maps most latin-decorated Unicode > characters into the non-decorated basic form. This is a fascinating article by Sean Burke (a linguist) about converting all Unicode characters into US-ASCII. Th

Re: [sqlite] Question about searches

2009-06-16 Thread John Machin
On 17/06/2009 1:19 AM, Christophe Leske wrote: >>> So far , so good, but my client also expects ANY simplification of a >>> character to be recognized: >>> Cote d'azur for instance should return "Côte d'azur" >>> or the Sao Paulo issue - how can a search for "Sao Paulo" return "Sào >>> Paulo" in

Re: [sqlite] Question about searches

2009-06-16 Thread Simon Slavin
On 16 Jun 2009, at 4:46pm, Swithun Crowe wrote: > How about having an extra column for each column that you want to > search > in? In the extra column, have a plain lowercase ASCII version of the > word. > So, for 'Sào Paulo', have 'sao paulo'. You would need to write a small > program to con

Re: [sqlite] Question about searches

2009-06-16 Thread Igor Tandetnik
Christophe Leske wrote: >> You write your own comparison function that would consider these two >> strings equal. See sqlite3_create_function, sqlite3_create_collation. >> > this problem pertains not only to Zürich, but to 24000 other entries, > so > I guess that this is no option for me. > And ag

Re: [sqlite] Question about searches

2009-06-16 Thread Swithun Crowe
Hello CL I can't know this beforehand. These are just examples, i need a generic CL solution if possivble. CL All i can see so far is to build a table of all special characters ever CL used in the 24000 names of cities which make problems and remap them CL accordingly. How about having an ext

Re: [sqlite] Question about searches

2009-06-16 Thread Christophe Leske
> You write your own comparison function that would consider these two > strings equal. See sqlite3_create_function, sqlite3_create_collation. > Well, this problem pertains not only to Zürich, but to 24000 other entries, so I guess that this is no option for me. And again, I am using the sql

Re: [sqlite] Question about searches

2009-06-16 Thread Igor Tandetnik
Christophe Leske wrote: > - how can SQlite be instructed to return search results which include > a > special character in it? > E.g. you search literally for "Zurich" on an englisch system and > expect > "Zürich" to be in the result set. You write your own comparison function that would consider

[sqlite] Question about searches

2009-06-16 Thread Christophe Leske
Hi there, i have written an application which runs under german and englisch versions of Windows. It includes a city databases which is ought to be searchable, yet there are a couple of issues which are of more logical nature... My shell application surrounding the sqlite database only supports