CODEWITHSUNDEEP
phputf-8character-encodingphpmyadmin
Micronax
Micronax

Reputation: 657

UTF-8 display-issues in PhpMyAdmin-Gui

I've got the following problem with my PMA-GUI:

While the data submitted by PHP-Scripts to my database is displayed correctly, ONLY PMA displays several german Umlaut's (such as äüß, ..) as ü or ä

The problem occurs also while exporting tables to file..

MySQL: 5.0.51a-3ubuntu5.8
PMA: 3.4.5
Database & fields are utf8_general_ci

Does anybody know a solution?

Upvotes: 3

Views: 1978

Answers (2)

SW4
SW4

Reputation: 71150

You need to ensure you use consistent use of character set/character encoding.

For example, to normalise to UTF-8 content, your DB fields' character sets should be set to UTF-8. Then, in your PHP (if you have your own scripts running that fetch DB information) you need to then add to the head section:

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

Then, in the PHP, before any output to the browser, include the content type PHP header:

header ('Content-type: text/html; charset=utf-8');

Before you run any SQL to fetch content (so after you connect, but before executing your query), use mysql_set_charset:

mysql_set_charset('utf8',$link); 
// $link is optional, refers to your DB connection

You can think of it as three steps:

  1. The step used to add the characters to your DB
  2. Storage of characters in your DB
  3. Retrieval and display of characters

The simplest bet to ensure conformity and that characters display as you anticipate, is to ensure the correct, consistant, character set is defined at each stage.

Upvotes: 2

Gianpaolo Di Nino
Gianpaolo Di Nino

Reputation: 1147

Are you sure that your client is sending data as utf-8?

this seems to me a duplicate of:

German Umlaute in Mysql/Phpmyadmin

Upvotes: 2

Related Questions