I am trying to xml dump my database which contains Cyrillic UTF8 text. In the result, the xml tags are displayed properly but the Cyrillic content comes out as garbage.

This does NOT happen when I do the regular SELECT queries...

What does that mean? Any idea why the two outputs would be differently encoded? And where should I look to fix this.

Beginner here, so please be gentle!

All best,
Toma

You should use --default-character-set=

Unfortunately, that's not it. Mysqldump is using utf8 by default, + I also tried to force utf8 as the character set during mysqldum, but I got the same results.

As I said, I have no problems with regular queries (SELECT, SET, INSERT...) -- everything is working out fine. I'm just suck with the dump.



All best,
T.