cpg1.4.3 databases

[pcotter]

I there,
Im getting problems with german characters, for example a user named Söenke apears S?ke in cpg databases...
The CPG database collation at MYSQL is latin1_swedish_ci, is that what is causing problems?

[Joachim Müller]

use utf-8 encoding! In the future, search before posting, this has been asked very often already!

[Cafeine]

Okay, I just spent an hour browsing this forum, no perfect answer : I do have "SOME" problems in my char encoding too. Sometimes "é à ç" are fine, some others aren't though. Can't find WHY. Anyway, my settings are UTF8 everywhere now. BUT in the database, I see "latin1_swedish_ci"  everywhere. (weird, i'm so not swedish )

What should i do then ??

[Joachim Müller]

happens when you upgrade: you have a mixture of text content in the db: some of it is utf-8, some isn't. That's why strange chars show. You should have converted the db when upgrading.

Joachim

P.S. Swedish is fine - it's in fact western/latin/iso8859-1. They display swedish just because mysql.com is a swedish company.