jollyjumper

Xpajun, on 11 January 2012, 08:27, said:

The problem are the payment modules and the payment actions afterwards. The wrong name or address is stored and sent via email by the payment provider.

Any ideas of a solution.

Quote

The text is entered via "new customer form" if i create a new customer.

Quote

The text is displayed correct on the frontend and backend. Only in phpMyAdmin the text is displayed wrong. The site is hosted on linux and also phpMyAdmin is installed there. I call the phpMyAdmin from my Win7 PC with eg. Chrome.

Hi,
i have nearly the same problem with the encoding and i also don't understand why because imho it's ALL set to UTF-8.

Database:
show variables like 'character_%';

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

Database-Table and character columns (e.g. customers):
collation: utf8_general_ci

Frontend:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

This was set with the german language file german.php (line 46):
// charset for web pages and emails
define('CHARSET', 'utf-8');

If i add a new customer with the characters ä,ö,ü,ß,Ä,Ö,Ü as a name or address it is displayed correctly in the front and backend but there are some unreadable characters (äöüß) in the database.

Can that be a display issue of the phpMyAdmin or did i forget something to configure?

Any help would be appreciated.
THX