Tuesday, 20 August 2013

Database is UTF-8, data shows up as ????? in page

Database is UTF-8, data shows up as ????? in page

I have an issue, i had a script to get some fields from a database and
print em out but after some updates on the software something is wrong
with UTF8 imo.
English is printed out just fine but for any greek i see ??????. Fields in
the database are utf8_general_ci.
Below is the script
function getaffiliateclientname($inputid)
{
$database="XXXXXXXX";
mysql_connect ("XXXXXXXXXXXXXXXXXXX");
@mysql_select_db($database) or die( "Unable to select database");
$data = mysql_query("SELECT firstname, lastname FROM hb_client_details
WHERE id = (SELECT client_id FROM hb_aff WHERE id=$inputid )")
or die(mysql_error());
while($info = mysql_fetch_array( $data ))
{
return $info['firstname'];
}
}
Any ides on what might be wrong?

No comments:

Post a Comment