Comments on: How MySQL Uses character_set Configurations https://www.percona.com/blog/how-mysql-uses-character_set-configurations/ Fri, 10 Feb 2023 12:35:37 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Edwin Wang https://www.percona.com/blog/how-mysql-uses-character_set-configurations/#comment-10973878 Wed, 28 Dec 2022 20:53:15 +0000 https://www.percona.com/blog/?p=84304#comment-10973878 Hey Ross,
Those conversions mentioned in the article are all internally applied by MySQL, so there is no need to do the implicit conversion. And so there is no performance concern.

]]> By: Ross https://www.percona.com/blog/how-mysql-uses-character_set-configurations/#comment-10973876 Tue, 27 Dec 2022 17:39:09 +0000 https://www.percona.com/blog/?p=84304#comment-10973876 Mr. Wang. Thank you for this article.

What are the performance impacts of the various character set conversions? Assume the use case of SELECT against a column with a field-specific, non-default charset/collation, does it make a performance difference if the system does the conversion implicitly, or whether an externally-invoked SET command is used?

Also, when and how are the conversions managed implicitly during, say, JOIN operations.

Thank you again.

]]>