By Skello on

Hello everyone,

I'm rather new to Drupal. I want to install Drupal 5.1 on my webhosting which runs MySQL - 5.0.26-standard. The question i am having is what COLLATION should i use on the MySQL DB that i create ?
utf8_bin
utf8_general_ci
utf8_unicode_ci
I don't want to encounter migration or upgrading problems later on. Also it is possible in the future that my website will have localized nodes with content translated in multiple languages.

Thank you.

⋅ Categories: Drupal 5.x

Comments

davemybes’s picture

davemybes commented

I believe that it should be be utf8_general_ci. The Drupal install should set that up automatically though. Be aware that sometimes, when you create the database, you can't select anything else but utf8 (without the _general_ci) - this is fine.

______________________________________________________________________________________________________
Need help? Check the FAQ and the Handbooks first.

______________________________________________________________________________________________________

Skello’s picture

Skello commented

Hi. Thank you for your input. I'm using PhpMyAdmin which allows me to manually select from all available charsets. I will go ahead with utf8_general_ci as you suggested.

pasquale’s picture

pasquale commented

https://techcommons.stanford.edu/drupal-book-toc/create-local-developmen... says to use utf8_unicode_ci

Which is it? and how do you know? and does it even matter if i choose between unicode or general? why?