Re: [sqlite] Question about searches

"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

Re: [sqlite] Question about searches

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

Re: [sqlite] Question about searches

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"

Re: [sqlite] Question about searches

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

Re: [sqlite] Question about searches

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

Re: [sqlite] Question about searches

> 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

Re: [sqlite] Question about searches

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

[sqlite] Question about searches

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