MySQL Database collation type for new install?

[pols1337]

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

[pols1337]

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

/resolved

[gmc]

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.

[Αndré]

FYI: cpg1.5.28 is the latest stable release.

[pols1337]

Thank you for both responses. 

Gonna be upgrading my Coppermine galleries this weekend ... don't suppose you'll have 2.0 released anytime soon?