> >
> > Ð ÐÐÐ, 23.08.2004, Ð 23:04, David Wheeler ÐÐÑÐÑ:
> > > On Aug 23, 2004, at 1:58 PM, Ian Barwick wrote:
> > >
> > > > er, the characters in "name" don't seem to match the characters in the
> > > > query - 'êëë' vs. 'ëíì' - does that have any bearing?
> > >
> > > Yes, it means that = is doing the wrong thing!!
> >
> > The collation rules of your (and my) locale say that these strings are
> > the same:
> >
> > [EMAIL PROTECTED] markus]$ cat > t
> > êëë
> > ëíì
> > [EMAIL PROTECTED] markus]$ uniq t
> > êëë
> > [EMAIL PROTECTED] markus]$
>
> wild speculation in need of a Korean speaker, but:
>
> [EMAIL PROTECTED]:~/tmp> cat j.txt
> ããã
> íêì
> ìêì
> ìëì
> êëë
> ëíì
> ããã
> [EMAIL PROTECTED]:~/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...
Locales for multibyte encodings are often broken on many platforms. I
see identical things with Japanese on Red Hat. This is one of the
reason why I tell Japanese PostgreSQL users not to enable locale while
initdb...
--
Tatsuo Ishii
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
