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: MySQL Database collation type for new install?  (Read 4450 times)

0 Members and 1 Guest are viewing this topic.

pols1337

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 244
MySQL Database collation type for new install?
« on: June 17, 2014, 04:32:42 am »

Hi there,

I'm setting up a new Coppermine installation 1.5.24 for a test gallery, and in my phpMyAdmin I have a choice for collation types (which I've never had to choose before).

What do I use? "utf8_general_ci"

Please advise.

Joel
Logged

pols1337

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 244
Re: MySQL Database collation type for new install?
« Reply #1 on: June 17, 2014, 04:43:15 am »

Well never mind.  I forgot that in the installation wizard, I could create a new database!

/resolved
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: MySQL Database collation type for new install?
« Reply #2 on: June 17, 2014, 12:50:31 pm »

Still a good questions - as some hosts require you to create the database via their cPanel... and Coppermine would then use it and define all tables.

The strong recommendation is to use charset UTF8 - which would then use the collation utf8-general-ci.

Use of other charsets is possible, but you may run into problems later if utf8 data is inserted (characters outside of other charsets... could be as simple as a character in a comment left by a user..)
MySQL attempts to deal with this - and not always in the best way... or in a way compatible with your next ISP...
Starting with - or converting to - UTF8 now will save those issues later.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: MySQL Database collation type for new install?
« Reply #3 on: June 17, 2014, 09:16:14 pm »

FYI: cpg1.5.28 is the latest stable release.
Logged

pols1337

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 244
Re: MySQL Database collation type for new install?
« Reply #4 on: June 22, 2014, 01:31:14 am »

Thank you for both responses. 

Gonna be upgrading my Coppermine galleries this weekend ... don't suppose you'll have 2.0 released anytime soon?  ;D  ;)  ::)
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.