Drupal site breaks with MySQL collation-server option
Hi everyone. This is doesn't have to be significative, but I've noticed that my Drupal 7.15 test site reset every connection attempt if I put this directive in my.cnf (MySQL config file): collation-server=utf8_spanish_ci Reverting the change of course brings back Drupal to its normal behavior, but I wonder the reason of that situation. Any ideas?? This is solely for learning purposes not for production settings ;) Many thanks in advance!
What happens if you set it directly in the database? Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: Jason P. This is doesn't have to be significative, but I've noticed that my Drupal 7.15 test site reset every connection attempt if I put this directive in my.cnf (MySQL config file):
collation-server=utf8_spanish_ci
Reverting the change of course brings back Drupal to its normal behavior, but I wonder the reason of that situation.
Any ideas?? This is solely for learning purposes not for production settings ;)
In fact the Drupal database, its tables and its contents are utf8_spanish_ci cause I've changed it (testing purposes) from the utf8_general_ci default setting. Everything seems to work fine until I do the little trick mentioned before, wether or not it makes sense. El 21/08/12 23:49, Ms. Nancy Wichmann escribió:
What happens if you set it directly in the database?
Nancy
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: Jason P. This is doesn't have to be significative, but I've noticed that my Drupal 7.15 test site reset every connection attempt if I put this directive in my.cnf (MySQL config file):
collation-server=utf8_spanish_ci
Reverting the change of course brings back Drupal to its normal behavior, but I wonder the reason of that situation.
Any ideas?? This is solely for learning purposes not for production settings ;)
Drupal likes utf8_general_ci. You can find more at http://bit.ly/Sja1o2. Earnie On Tue, Aug 21, 2012 at 5:41 PM, Jason P. <suscricions@gmail.com> wrote:
Hi everyone.
This is doesn't have to be significative, but I've noticed that my Drupal 7.15 test site reset every connection attempt if I put this directive in my.cnf (MySQL config file):
collation-server=utf8_spanish_ci
Reverting the change of course brings back Drupal to its normal behavior, but I wonder the reason of that situation.
Any ideas?? This is solely for learning purposes not for production settings ;)
Many thanks in advance! -- [ Drupal support list | http://lists.drupal.org/ ]
-- Earnie -- https://sites.google.com/site/earnieboyd
participants (3)
-
Earnie Boyd -
Jason P. -
Ms. Nancy Wichmann