auto suggest charset..

[techker]

hey guys im really going nuts on this..

im trying to get french characters to show in my auto complete...

any clue how?

<?php
   $db = new mysqli('localhost', '1' ,'1', '1');

if(!$db) {

	echo 'Could not connect to the database.';
} else {

	if(isset($_POST['queryString'])) {
		$queryString = $db->real_escape_string($_POST['queryString']);

		if(strlen($queryString) >0) {

			$query = $db->query("SELECT Nom,Prenom FROM Etudiant_2013 WHERE Prenom LIKE '$queryString%' LIMIT 10");
			if($query) {
			echo '<ul>';
				while ($result = $query ->fetch_object()) {
         			echo '<li onClick="fill(\''.addslashes($result->Nom).'\');">'.$result->Nom.'</li>';
         		}
			echo '</ul>';

			} else {
				echo 'OOPS we had a problem :(';
			}
		} else {
			// do nothing
		}
	} else {
		echo 'There should be no direct access to this script!';
	}
}
?>

[techker]

k i added

$db = new mysqli('localhost', '2' ,'2', '2')
  or die (mysqli_connect_error());
  mysql_set_charset('utf8');

[Ashley_Sheridan]

Couple of things you can try: a) make sure the PHP file(s) are saved as utf8 themselves, which should push the server to output utf8 headers, b) add a <meta> tag that indicates to the browser the document is in utf8, c) add a PHP header() call to force utf8 headers from the server.

[Bonesnap]

Is your auto-suggest based on jQuery's autocomplete plugin? If it is, check out what it has to say about "accent folding". Clickety