PHP 4.0 Bug #9047: Icelandic Special Character invalid

From: andrimar@netscape.net Operating system: Win98 PHP version: 4.0.3pl1 PHP Bug Type: MySQL related Bug description: Icelandic Special Character invalid Hello There seems to be a bug when parsing special Icelandic character ,such as æ-í-ó-á-é-ð-ö, to mysql 3.23.32 database Example: When I create a predefined table with a php form name it for exaðle æíö and check it by listing tables with php everything looks fine, the characters are correct, but when I login to the mysql server using mysql.exe and look at the table I created there are just signs, don't know what signs but definantly not what I wrote in the form. This is vice versa also....when I use mysql.exe to create a table which has Icelandic characters in it's name and list it with mysql.exe it's ok but when I do it with php the signscome back. Also I can't use uppercase letters...the mysql server always changes them to lowercase...this did not happend when I used PHP 4.0.3pl1 and mySQL 3.22.33 Please tell me how to correct this error I can't even write my own name in the database without some fuck ups Andri Mar Jónsson -- Edit Bug report at: http://bugs.php.net/?id=9047&edit=1