cpg1.4.3 databases cpg1.4.3 databases
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

cpg1.4.3 databases

Started by pcotter, January 01, 2006, 06:50:30 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

pcotter

January 01, 2006, 06:50:30 PM Last Edit: January 01, 2006, 06:57:28 PM by 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?
Dum Spiro, Spero
http://foto.pcotter.com

Joachim Müller

#1
January 02, 2006, 07:44:02 AM
use utf-8 encoding! In the future, search before posting, this has been asked very often already!

Cafeine

#2
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 ??

Joachim Müller

#3
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.
Print
Go Up Pages1
User actions