Character encoding


#1

I’ve created a db in MySQL with (utf-8) charset and connection collation (utf8_general_ci). The data shown in phpMyAdmin 2.6.4-pl3 is the right char. But I’m using PHP to retrieved the data and shown it in web browser is displayed as ?? char.

I’m just using the echo command to show the result directly as below.

---- code start ----

$area_query = mysql_query($area);
while($area_row = mysql_fetch_array($area_query))
{
echo “”.$area_row[“area_”.$la]." | ";
}

---- code end ----

Thx.


#2

Set page encoding to utf8 and insert this query after connecting to mysql server:
mysql_query(“SET NAMES ‘utf8’”);

…and enjoy :).


#3

where to set the code as you mentioned? I am sorry I am very stupid on MySQL.

Thanks!