Re: UTF-8 and LIKE vs =

Поиск
Список
Период
Сортировка
От Ian Barwick
Тема Re: UTF-8 and LIKE vs =
Дата
Msg-id 1d581afe04082317071dfca8ab@mail.gmail.com
обсуждение исходный текст
Ответ на Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
Ответы Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
Список pgsql-general
On Mon, 23 Aug 2004 16:50:04 -0700, David Wheeler <david@kineticode.com> wrote:
> On Aug 23, 2004, at 4:34 PM, Ian Barwick wrote:
>
> > wild speculation in need of a Korean speaker, but:
> >
> > ian@linux:~/tmp> cat j.txt
> > テスト
> > 환경설
> > 전검색
> > 웹문서
> > 국방비
> > 북한의
> > てすと
> > ian@linux:~/tmp> uniq  j.txt
> > テスト
> > 환경설
> > てすと
> >
> > All but the first and last lines are random Korean (Hangul)
> > characters. Evidently our respective locales think all Hangul strings
> > of the same length are identical, which is very probably not the
> > case...
>
> Does this go away if you change your locale to C?

Yes.

Ian Barwick

В списке pgsql-general по дате отправления:

Предыдущее
От: David Wheeler
Дата:
Сообщение: Re: UTF-8 and LIKE vs =
Следующее
От: "borajetta"
Дата:
Сообщение: Re: ERROR: duplicate key violates unique constraint "pg_class_oid_index"