Re: Accent insensitive search?

From: Christophe <xof(at)thebuild(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Accent insensitive search?
Date: 2009-03-18 18:35:42
Message-ID: 99820CC9-8A85-44FB-B814-89FC9D567208@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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')?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2009-03-18 19:16:55 Re: configure question
Previous Message Alvaro Herrera 2009-03-18 18:24:36 Re: Accent insensitive search?