coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: pcotter on January 01, 2006, 06:50:30 PM

Title: cpg1.4.3 databases
Post by: pcotter on January 01, 2006, 06:50:30 PM
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?
Title: Re: cpg1.4.3 databases
Post by: Joachim Müller on January 02, 2006, 07:44:02 AM
use utf-8 encoding! In the future, search before posting, this has been asked very often already!
Title: Re: cpg1.4.3 databases
Post by: Cafeine on February 15, 2006, 06:49:05 PM
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 ??
Title: Re: cpg1.4.3 databases
Post by: Joachim Müller on February 16, 2006, 09:52:16 AM
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.