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?
use utf-8 encoding! In the future, search before posting, this has been asked very often already!
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 ??
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.