Regular expressions failure - PHP & MYSQL

[hessodreamy]

Are mysql regular expressions supported in PHP 5.03?
I've run the query via PHP and got an error, but the query works fine when put straight into mysql. I've not come across this error message before and don't know how to get around it, but I have heard about some incompatibility issues.

Here's a sample query output from PHP:

SELECT prodName FROM tProducts WHERE `prodName` REGEXP '[[:<:]]chair[[:>:]]'

and the error:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'regexp' 

[nemonoman]

Have a good time exploring how to solve this using google. Here is the problem:

Your browser character set (set via a header(), or via a <META, or via your HTTPD.conf file) is UTF-8.

You need to set your search column-type to UTF-8, or send header or <META code in your browser page consistent with the MySQL datatype.