> 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.
I also recall there there were problems with multi-byte LIKE still being
worked on in 8.0.
One question, though, what do you get if you do:
bric=# select * from keyword where name ~ '^북한의';
Aglio Database Solutions
In response to
- LIKE vs = at 2004-08-23 17:39:38 from David Wheeler
sfpug by date
|Next:||From: David Fetter||Date: 2004-08-23 17:46:20|
|Subject: Re: LIKE vs =|
|Previous:||From: David Wheeler||Date: 2004-08-23 17:39:38|
|Subject: LIKE vs =|