in reply to Is it perl or MySQL? ü ends up in CGI script

Now I configured my environment right:
| character_set_client | utf8
| character_set_connection | utf8
| character_set_database | utf8
| character_set_filesystem | binary
| character_set_results | utf8
| character_set_server | utf8
| character_set_system | utf8
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | utf8_general_ci
| collation_database | utf8_general_ci
| collation_server | utf8_general_ci

But the problem persists in a new iteration:
in phpmyadmin: the same ü for ü
but now, also via console # mysql > SELECT ...
I get garbled data. So far it seemed a problem of the output only....

Any ideas?
  • Comment on Re: Is it perl or MySQL? ü ends up in CGI script

Replies are listed 'Best First'.
Re^2: Is it perl or MySQL? ü ends up in CGI script
by moritz (Cardinal) on Feb 08, 2008 at 16:17 UTC
    Does that happen for clean UTF-8 data that you inserted after changing the configuration?
[reply]
      Yes, but now it works, as can be seen in my update, two more line of configuration make a difference (altough I don't fully understand, what I did...)
[reply]

In Section Seekers of Perl Wisdom