Join the community today
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 Well-Known Member

    2,469
    223
    63
    May 31, 2014
    Ratings:
    +382
    Local Time:
    3:41 PM
    Nginx-1.13.x
    MariaDB 10.1.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

    28,487
    6,469
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,583
    Local Time:
    10:41 PM
    Nginx 1.13.x
    MariaDB 5.5
    @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/