On Thu, 25 Sep 2003, Michael A Nachbaur wrote:
> I've created the following stored procedure to allow me to do
> international-insensitive text searches, e.g. a search for "Resume" would
> match the text "Résumé".
>
> I wanted to know:
>
> a) am I missing any characters that need to be convert
Michael A Nachbaur writes:
> a) am I missing any characters that need to be converted?
In Unicode, any character can be dynamically combined with any number of
accent characters, so an enumerated list will never do.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of br
On Thursday 25 September 2003 05:06 pm, Manuel Sugawara wrote:
> Michael A Nachbaur <[EMAIL PROTECTED]> writes:
> > b) is there a better and/or faster way of implementing this? I
> > don't want searches to bog down (at least too badly) as a result of
> > this.
>
> Use to_ascii(text),
[snip]
D'oh
Michael A Nachbaur <[EMAIL PROTECTED]> writes:
> b) is there a better and/or faster way of implementing this? I
> don't want searches to bog down (at least too badly) as a result of
> this.
Use to_ascii(text),
masm=# select to_ascii('áéíóú');
to_ascii
--
aeiou
(1 row)
Regards,
Manuel
I've created the following stored procedure to allow me to do
international-insensitive text searches, e.g. a search for "Resume" would
match the text "Résumé".
I wanted to know:
a) am I missing any characters that need to be converted? My first (and only
language) is English, so I'm in the d
