Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: MySQL Database collation type for new install?  (Read 5785 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: 15764
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.021 seconds with 19 queries.