使用特殊字符调用时，mysql_query不返回任何内容（丹麦字符：æøå）

Question

I generate a mysql query from a form with a free text search field.
Something like:
SELECT ... FROM ... WHERE 'something' LIKE '%SEARCH%'

All this works fine and returns the valid rows when the search does not contain any special characters, like the danish characters ÆØÅ.

When these letters ARE used, the query returns no results, all though when i take the generated query string and plug it into phpMyAdmin i get exacly the result i want.

Thanks

Answer 1

add this line of code in your connection file...

mysql_set_charset("utf8", $db);

it is better for you to encode your data to UTF-8 before you pass it into query...