Re: Accent insensitive search? - Mailing list pgsql-general

From Christophe
Subject Re: Accent insensitive search?
Date
Msg-id 99820CC9-8A85-44FB-B814-89FC9D567208@thebuild.com
Whole thread Raw
In response to Re: Accent insensitive search?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
On Mar 18, 2009, at 11:24 AM, Alvaro Herrera wrote:
> Hmm, if to_ascii() doesn't work, that's something worth some research.
> Maybe the encoding config is broken, for example.

The docs say to_ascii() only works with LATIN1, LATIN2, LATIN9, and
WIN1250; maybe convert('string', 'UTF-8', 'SQL_ASCII')?

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Accent insensitive search?
Next
From: Peter Eisentraut
Date:
Subject: Re: configure question