Oldenborg Oldenborg - 22 days ago 6
MySQL Question

PHP MySQL utf 8 encoding

My trying to make an Ajax call to a PHP function that pulls out data from my database. I've run into a problem though.

My query looks like this

$query = "SELECT * FROM mytable WHERE field LIKE '%$string%'"


I then check on the number of rows returned by the query, but when i type in æ ø å then i my query returns 0 rows, although I know there are entries in the database that have æ ø å.. why is this

Answer

Set the connection to use UTF-8:

<?php

// MySQLi:

$connection = new MySQLi( /* ... credentials ...*/);
$connection->set_charset("utf8");


// MySQL:
$connection = mysql_connect(/* ... credentials ... */); 
mysql_set_charset("utf8", $connection);

?>