Hello,
I've upgraded from MySql4.0.x to 4.1.12. Now I've a problem with the german character-set. Especially the letters äöüÄÖÜß.
These letters are converted in low ASCII letters in the database, so ifI retrieve text with these letters I get cryptic letters like ? or not writeable letters back.
I'd read a little in forums and found some tips, but I didn't solve the problem until now.
I run MySql on Windows XP as a service. I use only one configure file: my.ini in the Mysql-Programdirectory.
I use the following parameters in my.ini:
default-charset=latin1
default-collation=latin1_german1_ci
I tried to repair all databases with the command mysqlrepair
Then I made a backup of all databases with mysqldump and created all databases new.
Then I tried to repair the databases again with mysqlcheck -A -c --auto-repair
As I said before, all these actions didn't have any effect.
I'm deeply grateful for anny further suggestions.
Kostarsus
I've upgraded from MySql4.0.x to 4.1.12. Now I've a problem with the german character-set. Especially the letters äöüÄÖÜß.
These letters are converted in low ASCII letters in the database, so ifI retrieve text with these letters I get cryptic letters like ? or not writeable letters back.
I'd read a little in forums and found some tips, but I didn't solve the problem until now.
I run MySql on Windows XP as a service. I use only one configure file: my.ini in the Mysql-Programdirectory.
I use the following parameters in my.ini:
default-charset=latin1
default-collation=latin1_german1_ci
I tried to repair all databases with the command mysqlrepair
Then I made a backup of all databases with mysqldump and created all databases new.
Then I tried to repair the databases again with mysqlcheck -A -c --auto-repair
As I said before, all these actions didn't have any effect.
I'm deeply grateful for anny further suggestions.
Kostarsus