Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB Convert them to utf8 before adding a database

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by pamamolf, Jun 25, 2014.

  1. pamamolf

    pamamolf Well-Known Member

    3,103
    294
    83
    May 31, 2014
    Ratings:
    +527
    Local Time:
    1:37 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Hi

    Running this:

    Code:
    mysqladmin -u root -p var | grep -E 'character|collation' | tr -s ' '
    i got:

    Code:
    | character_set_client | latin1 |
    | character_set_connection | latin1 |
    | character_set_database | latin1 |
    | character_set_filesystem | binary |
    | character_set_results | latin1 |
    | character_set_server | latin1 |
    | character_set_system | utf8 |
    | character_sets_dir | /usr/share/mysql/charsets/ |
    | collation_connection | latin1_swedish_ci |
    | collation_database | latin1_swedish_ci |
    | collation_server | latin1_swedish_ci |
    
    How can i change them to utf8 before i add any database?

    Thanks
     
  2. eva2000

    eva2000 Administrator Staff Member

    34,585
    7,651
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,767
    Local Time:
    8:37 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
..