Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Should I use utf8mb4 instead utf8?

Tags:

utf-8

utf8mb4

What practical advantages and disadvantages does utf8mb4 provide, except ability to use Emoji? As I understand it takes more space to store.

like image 708
ProgZi Avatar asked Jun 10 '16 01:06

ProgZi


1 Answers

utf8mb4 handles Emoji and some Chinese characters that are missing from utf8. There are other, less common, characters. Read about the Unicode planes, realizing that the BMP is the only plane handled by MySQL's utf8.

As for space... For characters that exist in utf8, utf8mb4 takes the same amount of space.

like image 61
Rick James Avatar answered Sep 22 '22 12:09

Rick James