forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 install => Topic started 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
-
Well never mind. I forgot that in the installation wizard, I could create a new database!
/resolved
-
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.
-
FYI: cpg1.5.28 is the latest stable release.
-
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 ;) ::)