Re: how to ignore accents?

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/