Re: MySQL + Collation (utf8_swedish_ci){urgent}

[Bernd Drautzburg]

uff, hard to say. some hints where i would start:

- is it sure that data in the db changed after some days (client window not set to utf8 or such things..)

- is there a (web) application running some updates, perhaps with 'Arbetsförhållanden' being send to the server again in a different encoding? is the client-side encoding always set correctly (set names 'utf8')?

you can enable the binlog and use the command 'mysqlbinlog' - this way, you can watch out for queries that may cause data changes. however - depending on your binlog size - this is no fun.

Bernd