Skip site navigation (1) Skip section navigation (2)

Re: UTF-8 and LIKE vs =

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: David Wheeler <david(at)kineticode(dot)com>
Cc: Ian Barwick <barwick(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-23 22:46:50
Message-ID: 1093301210.2726.7.camel@teetnang (view raw or flat)
Thread:
Lists: pgsql-general
В Пнд, 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:

[markus(at)teetnang markus]$ cat > t
국방비
북한의
[markus(at)teetnang markus]$ uniq t
국방비
[markus(at)teetnang markus]$

Make sure that you have initdb'd the database under the right locale.
There's not much PostgreSQL can do if strcoll() says that the strings
are equal.

-- 
Markus Bertheau <twanger(at)bluetwanger(dot)de>


In response to

Responses

pgsql-general by date

Next:From: David WheelerDate: 2004-08-23 22:50:07
Subject: Re: UTF-8 and LIKE vs =
Previous:From: Tom LaneDate: 2004-08-23 22:44:47
Subject: Re: UTF-8 and LIKE vs =

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group