MySQL 8.0: Improved UTF8, Unicode, Collations

[Edwin Desouza]

MySQL 8.0: Improved UTF8, Unicode, Collations

presentations:
- https://www.slideshare.net/BerntMariusJohnsen/collations-in-mysql-80
- http://www.slideshare.net/BerntMariusJohnsen/mysql-80-unicode-why-what-how


blogs:
- https://blogs.oracle.com/mysql/mysql%3a-character-sets%2c-unicode%2c-and-uca-compliant-collations
- http://mysql.wisborg.dk/2018/07/28/which-character-set-should-you-use-in-mysql/
- https://mysqlserverteam.com/debugging-character-set-issues-by-example/
- http://mysqlserverteam.com/mysql-8-0-when-to-use-utf8mb3-over-utf8mb4/
- http://mysqlserverteam.com/sushi-beer-an-introduction-of-utf8-support-in-mysql-8-0/


Collations:
- https://mysqlserverteam.com/mysql-8-0-collations-migrating-from-older-collations-part-2/
- http://mysqlserverteam.com/mysql-8-0-collations-migrating-from-older-collations/
- http://mysqlserverteam.com/mysql-8-0-1-japanese-collation-for-utf8mb4/
- http://mysqlserverteam.com/mysql-8-0-1-accent-and-case-sensitive-collations-for-utf8mb4/
- http://mysqlserverteam.com/mysql-8-0-collations-the-devil-is-in-the-details/
- http://mysqlserverteam.com/new-collations-in-mysql-8-0-0/

UTF8 benchmarks:
- http://dimitrik.free.fr/blog/posts/mysql-performance-80-ga-more-in-depth-latin1-utf8mb4.html
- http://dimitrik.free.fr/blog/archives/2018/04/mysql-performance-80-and-utf8-impact.html
- https://www.percona.com/blog/2019/02/27/charset-and-collation-settings-impact-on-mysql-performance/


MySQL 8.0: Regular expressions
- https://mysqlserverteam.com/new-regular-expression-functions-in-mysql-8-0/
- https://mysqlserverteam.com/mysql-8-0-regular-expressions-and-character-properties/

Japanese:
- http://mysqlserverteam.com/mysql-8-0-kana-sensitive-collation-for-japanese/
- http://mysqlserverteam.com/mysql-8-0-1-japanese-collation-for-utf8mb4/


Debugging Character Set Issues by Example
- http://mysqlserverteam.com/debugging-character-set-issues-by-example/

UDFs and Character Sets:
- https://mysqlserverteam.com/a-tale-of-udfs-with-character-sets/

Upgrade and UTF8:
- https://saveriomiroddi.github.io/An-in-depth-dbas-guide-to-migrating-a-mysql-database-from-the-utf8-to-the-utf8mb4-charset/



Edited 22 time(s). Last edit at 07/22/2021 11:18AM by Edwin Desouza.