Re: LIKE vs =

On Aug 23, 2004, at 10:42 AM, Josh Berkus wrote:

>> Any idea why = works here and LIKE wouldn't?
>
> Yes. I believe that LIKE relies on the database encoding, whereas =
> does a
> direct byte comparison. However, I don't have much experience with
> encoding
> issues, so you might be better off asking someone else.

Yes, well, the database is utf-8, and I'm passing in a utf-8 string. At
least I hope it's utf-8. I created the database like this:

CREATE DATABASE "bricolage" WITH ENCODING 'UNICODE';

> I also recall there there were problems with multi-byte LIKE still
> being
> worked on in 8.0.

Oh, great.

> One question, though, what do you get if you do:
>
> bric=# select * from keyword where name ~ '^북한의';

No rows.

Regards,

David

--
David Wheeler
President, Kineticode, Inc.
http://www.kineticode.com/
Kineticode. Setting knowledge in motion.[sm]