Re: how to ignore accents? - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: how to ignore accents?
Date
Msg-id 20050331162919.GA43545@winnie.fuhr.org
Whole thread Raw
In response to Re: how to ignore accents?  ("Celia McInnis" <celia@drmath.ca>)
List pgsql-novice
On Thu, Mar 31, 2005 at 07:40:04AM -0600, Celia McInnis wrote:
> Thanks, Michael - I just tried your suggestion in postgresql 8.0.1 and
> unfortunately it doesn't work. How long will it be before 8.0.2 moves out of
> beta mode?
>
> Here's the error which I get in 8.0.1:
>
> ERROR: invalid byte sequence for encoding "UNICODE": 0xe76169

This is an encoding issue, not a difference between 8.0.1 and
8.0.2beta1.  I should have mentioned that the example works with
SQL_ASCII; apparently you're using UNICODE.  Try using your character
set's versions of the accented characters instead of the escape
sequences shown in the example.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: "Celia McInnis"
Date:
Subject: Re: how to ignore accents?
Next
From: Michael Fuhr
Date:
Subject: Re: Boolean search