| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wheeler | 2004-08-23 22:50:07 | Re: UTF-8 and LIKE vs = |
| Previous Message | Tom Lane | 2004-08-23 22:44:47 | Re: UTF-8 and LIKE vs = |