Dump restore - Character Set

[roblaus]

Hi,

I have a weird problem: the data of my demo version is reset every night by running a simple cron job that restores a previous dump. Tables are dropped and re-created.
During normal operation I can enter/save special characters (German Umlaute) and they are retrieved/shown correctly, But the restored data always is wrong (as in showing funny signs rather than letters).

I am almost 100% sure that this started with version 5.1. The dump was made with version 5.1 and just to be on the safe side I fixed the errors once from within Sugar and then again directly on the table and created new dumps. No change. I did open the .sql files on my local PC but I did not save them. So no chance that the character set was changed locally.

Sugar 5.1ce
Litespeed
php5
mysql5
Ubuntu 7.1 Server, 8.04 client

Any idea is appreciated

rgds
rl

[roblaus]

After various tests it turns out that this time Sugar is not the culprit. But I still do not understand it. The restore as command line task (cron job) destroys my special characters. The same file imported through phpmyadmin leaves everything intact.

I am still looking for an explanation because I find it a bit hard to get up every day at midnight to run my restore manually...

Any help is greatly appreciated.

rgds
rl

[sunside]

I don't really know if this helps, but every time before I play in a restore, I have to type

 charset utf8; 
  

into the mysql command line, and then it will recognize the special chars...

[roblaus]

Thanks, I will try this - maybe I should check the MYSQL manual...

[edit] - yes, I inserted the default char set command and everything is fine now. But it's still hard to understand because phpmyadmin reports the server to be utf8 (not the collation, the char set).

However - thx again for the help

rgds
rl