Re: how to ignore accents?

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: how to ignore accents?
Дата
Msg-id 20050331162919.GA43545@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: how to ignore accents?  ("Celia McInnis" <celia@drmath.ca>)
Список 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 по дате отправления:

Предыдущее
От: "Celia McInnis"
Дата:
Сообщение: Re: how to ignore accents?
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Boolean search