MySQL Forums :: InnoDB :: utf8 and utf8mb4 performance difference


Advanced Search

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
utf8 and utf8mb4 performance difference 622 hua kai 09/09/2016 07:25AM
Re: utf8 and utf8mb4 performance difference 453 Rick James 09/10/2016 10:48PM
Re: utf8 and utf8mb4 performance difference 344 hua kai 09/12/2016 08:55PM
Re: utf8 and utf8mb4 performance difference 303 Rick James 09/13/2016 04:07PM
Re: utf8 and utf8mb4 performance difference 316 hua kai 09/18/2016 12:20AM
Re: utf8 and utf8mb4 performance difference 289 Peter Brawley 09/18/2016 01:40PM
Re: utf8 and utf8mb4 performance difference 302 hua kai 09/19/2016 02:14AM
Re: utf8 and utf8mb4 performance difference 428 Xing Zhang 09/20/2016 08:38PM
Re: utf8 and utf8mb4 performance difference 299 hua kai 09/25/2016 01:20AM
Re: utf8 and utf8mb4 performance difference 287 Rick James 09/30/2016 08:04PM


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.