Re: search on accents -> Why not include this function - Mailing list pgsql-admin

From Jaume Teixi
Subject Re: search on accents -> Why not include this function
Date
Msg-id 20010329201811.3ea8c501.teixi@6tems.com
Whole thread Raw
In response to Re: search on accents -> Why not include this function  (Peter Eisentraut <peter_e@gmx.net>)
Responses How to place a table on a separate partition?  ("Rodin A. Porrata" <porrata@west.llnl.gov>)
Re: search on accents -> Why not include this function  (Patrice Hédé <patrice@islande.org>)
List pgsql-admin
But the thing is that you must explicity call this function in order to
use it.
Also in order to some stetics maybe you should call it accents_iso-8859-1
The thing is that this should be consider a big need for non-english
languages.

On a major approx also could be possible to modify it in order to accept
parameters to include ('å','à') or ('ca_ES','fr_FR')....

bests,
jaume.


> For the reason I cited above:  it is a too abstract approach for many
> languages and/or applications.  For example in Swedish, a search for 'e'
> should probably include 'é', since most users will not type that in
> explicitly (it's not on the keyboard), but a search for 'a' should
> normally not include 'å', since that it a completely separate letter
(and
> it is on the keyboard).  Additionally, this particular implementation
> seems to be ISO-8859-1 charset specific.  I know a number of accented
> letters that are a lot closer "siblings" to 'd' than 'ð' is.
>
> --
> Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: search on accents -> Why not include this function
Next
From: DHSC Webmaster
Date:
Subject: Re: PG 7.0.3 & RH 7 IPC problems?