you are right - utf-8 works now
Dear Ray,
you are right! I am so relieved. This has been a big issue with my clients. Because for Europeans their langauage does not have special characters. They are part of our everyday life.
Sweet girl means süßes Mädchen. So it should work if you name a picture. And with this version it works.
Thanks again
PS.:
Don't forget to update your Connections file to something like:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_whatever = "whatever host";
$database_whatever = "whatever database";
$username_whatever = "whatever_username";
$password_whatever = "whatever_password";
$whatever = mysql_pconnect($hostname_whatever, $username_whatever, $password_whatever) or trigger_error(mysql_error(),E_USER_ERROR);
$result0 = mysql_query('SET NAMES utf8');
if (!$result0) {
die('invalid request: ' . mysql_error());
}
?>
If I did not put the SET NAMES utf8 line, it would write wrong characters into the database again.