[RESOLVED] Problem with encoding

mikawhat

I have inserted some records manually from phpmyadmin using greek characters, but when i retrive those records with php i get something like ?????????? ??????. Is there a way to fix this problem?

mikawhat

i found a solution for this problem. i added mysql_query("SET NAMES 'utf8'"); in the db connection file.

Teodorius

I tried the solution suggested here but it doesn't work in my case.
Used this also

mysql_query("SET character_set_names = 'utf8', SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8_general_ci', character_set_server = 'utf8'", $conn);

But didnt solve my problem. I also need to display Greek and still get ???? ???? characters. Any ideas on how to solve this is appreciated!

NogDog

Teodorius;11003553 wrote:
I tried the solution suggested here but it doesn't work in my case.
Used this also

mysql_query("SET character_set_names = 'utf8', SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8_general_ci', character_set_server = 'utf8'", $conn);

But didnt solve my problem. I also need to display Greek and still get ???? ???? characters. Any ideas on how to solve this is appreciated!

Have you set the Content-Type HTTP [man]header[/man] to specify UTF-8 as the character set? (You can also set it in a HTML meta tag to make doubly sure.)

Teodorius

Problem solved thank you!

tsesterchris

Hi!! I am new in php and I actually have the same problem. How do I do the header thing I have no idea.

Ashley_Sheridan

First result from the keywords "php" and "header":

http://uk.php.net/manual/en/function.header.php