MySQL Forums
Forum List  »  InnoDB

Re: utf8 and utf8mb4 performance difference
Posted by: Rick James
Date: September 10, 2016 10:48PM

Is the difference between utf8 and utf8mb4 big enough to be measurable? I doubt it. Essentially the only difference is how many bytes a character is allowed to be. utf8 is a subset of utf8mb4.

Yes, different columns in a table can have different CHARACTER SETs and COLLATIONs. It is quite reasonable to have a mixture.

The default character set specified on the table is just that -- a default.

Options: ReplyQuote


Subject
Views
Written By
Posted
736
September 09, 2016 07:25AM
Re: utf8 and utf8mb4 performance difference
502
September 10, 2016 10:48PM
393
September 12, 2016 08:55PM
368
September 18, 2016 12:20AM
336
September 19, 2016 02:14AM
370
September 25, 2016 01:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.