Advanced search  

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]

Pages: [1]   Go Down

Author Topic: cpg1.4.3 databases  (Read 2821 times)

0 Members and 1 Guest are viewing this topic.

pcotter

  • Translator
  • Coppermine novice
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 28
  • Cotter
    • Personal Page
cpg1.4.3 databases
« 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?
« Last Edit: January 01, 2006, 06:57:28 pm by pcotter »
Logged
Dum Spiro, Spero
http://foto.pcotter.com

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: cpg1.4.3 databases
« Reply #1 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!
Logged

Cafeine

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 21
    • Cafzone
Re: cpg1.4.3 databases
« Reply #2 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 ??
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: cpg1.4.3 databases
« Reply #3 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.
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.021 seconds with 20 queries.