Citat:
Posted by Alan Ng on November 7 2009 3:17am
I can't believe I'm the first to post this solution, since the pain of MySQL's REGEXP not working with multibyte character sets has been expressed all over the Web for years, I see.
Here's my simple workaround, for a database, server, and current connection that are entirely in UTF-8. Of course this only helps the majority of us developers who are in fact dealing with stored data that could just as well have be expressed in latin1:
Kôd:
SELECT * FROM YourTables WHERE (CONVERT (TextField USING latin1)) REGEXP CONVERT ('YourUTF8RegExp' USING latin1))
|
Nisam nikad koristio REGEXP za MySQL, ovo gore sam pronašao na prvo guglanje, iz 2009. ne znam da li se u međuvremenu nešto promenilo.
http://www.google.com/search?ie=UTF-...0REGEXP%20utf8