Link to home
Start Free TrialLog in
Avatar of Rocking Buddy
Rocking BuddyFlag for India

asked on

Best Collation & Charset combination

Hi,


Which is the best combination


ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ASKER CERTIFIED SOLUTION
Avatar of gr8gonzo
gr8gonzo
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

Hello,


you have an interesting debate on this post : "mysql - What's the difference between utf8_general_ci and utf8_unicode_ci? - Stack Overflow "


- utf8mb4 means that all (international) possible characters (3 and 4 bytes) can be used and saved correctly.

- The unicode collation allows you to have the most standard sort and usage.

- The General collation seems to a little quicker, but doing some approximations, that can lead to problems.