Have a problem whith UTF-8

[nakama]

Sorry for my poor English.
I am trying to use a DB here at first time.

1) I have working site on my localhost (XAMPP, Mysql, PHP, UTF-8).
2) I read the HELP and created the DB, changed collation from latin1_danish_ci to utf8_general_ci.
3) I imported DB from file.sql (using MysqlDump).
4) I can see all the data from phpMyAdmin, there are no problems with characters. All tables have the utf8_general_ci.
5) But I have a problem on the site itself:

できるWord&Excel 2010
looking as
???Word&Excel 2010

Give me some advises, please.

 

[xav0989]

make sure that php is reading and displaying the data as utf 8

 

[nakama]

delete the DB, create a new. Checking...

show variables like "char%";

character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/

that`s the answer. No UTF8 support.

 

[xav0989]

In the php code as well, you need to make sure that PHP sends the information that the content is encoded in UTF-8.