0

These are the default character and collation settings on MySQL 5.5.62 version:

  mysql> show variables like "%character%";show variables like 
  "%collation%";
   +--------------------------+----------------------------+
   | Variable_name            | Value                      |
   +--------------------------+----------------------------+
   | character_set_client     | utf8                       |
   | character_set_connection | utf8                       |
   | character_set_database   | latin1                     |
   | character_set_filesystem | binary                     |
   | character_set_results    | utf8                       |
   | character_set_server     | latin1                     |
   | character_set_system     | utf8                       |
   | character_sets_dir       | /usr/share/mysql/charsets/ |
   +--------------------------+----------------------------+


   +----------------------+-------------------+
   | Variable_name        | Value             |
   +----------------------+-------------------+
   | collation_connection | utf8_general_ci   |
   | collation_database   | latin1_swedish_ci |
   | collation_server     | latin1_swedish_ci |
   +----------------------+-------------------+

I would like to change permanently the following parameters to latin1 :

   character_set_client=latin1
   character_set_connection=latin1
   character_set_results=latin1
   collation_connection=latin1

I have already tried unsuccessfully to adjust my.cnf with those values,but while restarting mysql ,the daemon does not even start. Any ideas?

  • Have you looked in the logs? – womble Mar 11 at 1:27
0
collation_connection=latin1

latin1 is not a collation. latin1_swedish_ci is.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.