Re: [GENERAL] UTF-8 and LIKE vs =

[David Wheeler]

On Aug 23, 2004, at 3:46 PM, Markus Bertheau wrote:

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]$

Interesting.

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.

Well, I have data from a number of different locales in the same database. I'm hoping that setting the locale to "C" will do the trick. It seems to work properly on my Mac:

sharky=# select * from keyword where name = '국방비';
 id |  name  | screen_name | sort_name | active
----+--------+-------------+-----------+--------
  0 | 국방비 | 국방비      | 국방비    |      1
(1 row)

sharky=# select * from keyword where name = '북한의';
 id | name | screen_name | sort_name | active
----+------+-------------+-----------+--------
(0 rows)

sharky=# select * from keyword where name like '북한의';
 id | name | screen_name | sort_name | active
----+------+-------------+-----------+--------
(0 rows)

sharky=# select * from keyword where lower(name) like '국방비';
 id |  name  | screen_name | sort_name | active
----+--------+-------------+-----------+--------
  0 | 국방비 | 국방비      | 국방비    |      1
(1 row)

Regards,

David

smime.p7s
Description: S/MIME cryptographic signature