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

utf8mb4_general_ci VS utf8_general_ci

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

  1. pamamolf

    pamamolf Premium Member Premium Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +837
    Local Time:
    12:21 PM
    Nginx-1.26.x
    MariaDB 10.6.x
    Hi

    Why i can see as default on phpmyadmin centminmod addon the utf8mb4_general_ci?

    Is it better or faster than utf8_general_ci ?

    I know i can change it but i am curious :)

    Or is it better to use even utf8_unicode_ci ?

    What is the default and better that the most forums/blogs uses?


    Thanks
     
    Last edited: Jun 9, 2014
  2. eva2000

    eva2000 Administrator Staff Member

    55,197
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    7:21 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    @pamamolf where are you seeing that ? Read on my blog http://vbtechsupport.com/1375/ to be clear of the differences between phpmyadmin default session character set and collation versus your database defaults. They are 2 different things. It could phpmyadmin default session collation is set different for some specific support ?

    http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-sets.html

    so it looks for better and wider compatibility phpmyadmin session only defaults to utf8mb4. You need to check what you databases default to as that would be different from phpmyadmin session defaults as per explanation at http://vbtechsupport.com/1375/