"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
>
-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
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
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
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
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
> 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
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
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
9 matches
Mail list logo