Re: UTF-8 and LIKE vs = - Mailing list pgsql-general

From David Wheeler
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id 282C6158-F55F-11D8-990D-000A95972D84@kineticode.com
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (Ian Barwick <barwick@gmail.com>)
Responses Re: UTF-8 and LIKE vs =
List pgsql-general
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?

Regards,

David

Attachment

pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: UTF-8 and LIKE vs =
Next
From: David Wheeler
Date:
Subject: Re: UTF-8 and LIKE vs =