forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 install => Topic started by: pols1337 on June 17, 2014, 04:32:42 am

Title: MySQL Database collation type for new install?
Post by: pols1337 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
Title: Re: MySQL Database collation type for new install?
Post by: pols1337 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
Title: Re: MySQL Database collation type for new install?
Post by: gmc 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.
Title: Re: MySQL Database collation type for new install?
Post by: Αndré on June 17, 2014, 09:16:14 pm
FYI: cpg1.5.28 is the latest stable release.
Title: Re: MySQL Database collation type for new install?
Post by: pols1337 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  ;)  ::)