How to Prevent UTF8MB4 From Truncating Indexes

Long utf8mb4 keys can exceed index limits.

#mysql #utf8mb4 #index #howto #schema #bug

https://www.youtube.com/watch?v=H8_KHnIP7zk

How to Prevent UTF8MB4 From Truncating Indexes #index

YouTube

UTF8MB4 Emoji Support EXPLODES Table From 500GB to 2TB?!

CHARACTER SET BOMB! Changed to utf8mb4 for emoji support! Table size EXPLODES 4x overnight! 500GB becomes 2.1TB! Disk fills up during ALTER! Database goes READ-ONLY! Watch this explosion!

#sql #sqldisaster #utf8mb4 #emoji #storageexplosion #altertable #sqlfails #diskfull #sqlshorts #databasedisaster #sqlwtf #characterset

https://www.youtube.com/watch?v=tKskvRTOkX0

UTF8MB4 Emoji Support EXPLODES Table From 500GB to 2TB?! #sqlshorts

YouTube
久しぶりに自分のホームページを更新。
MySQLにあるutf8mb4、この「4」が実際に見られるようサービスを改良しました。
こちらのサービスで絵文字を入力するとutf8の4バイトが見られます。
絵文字のバイト列を表示する世界唯一のサービスです・・・とか言っとけば親切な人が先駆者を教えてくれるハズ。 #utf8 #utf8mb4 #fedibird
絵文字を含む文字列を分割 - サービス - ルモーリン https://www.lemorin.jp/service/0e_split_char.html
絵文字を含む文字列を分割 - サービス - ルモーリン

これとかコードポイント8個で構成されています→「👩‍❤️‍💋‍👨(👩‍❤️‍💋‍👨)」 たこルカ(コードポイント1個)→「🐙(&#x1f

How to Change Column Collation in MySQL
Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands & automation tips! #MySQL #Collation #Database #SQL #CharacterSet #UTF8MB4
https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/
...
How to Change Column Collation in MySQL
Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands & automation tips! #MySQL #Collation #Database #SQL #CharacterSet #UTF8MB4
https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/
...

Technical people of the Interwebs, I have a question

If I were to create a table in a MySQL database with a field called emoji of type VarChar, what size would it need to hold a single emoji from all available (and future) emoji characters? I’m using utf8mb4 encoding.

#emoji #MySQL #utf8mb4 #VarChar

Ratet, wie ich herausgefunden habe, dass #Acrobat keine #utf8mb4 #emoji‍s in PDF-Anmerkungen verarbeiten kann. 🤬 #AllesWeg

Uh-oh #MySQL #utf8mb4

And it’s still open!

utf8mb4 support · Issue #750 · Piwigo/Piwigo

Piwigo currently supports the 3byte utf8 not the full one

Nextcloud with utf8mb4

I finally manged to convert my #Nextcloud database to use #utf8mb4 in a way the updater doesn't fail. The key was to switch to MariaDB's innodb_file_format 'Barracuda'.

my.cnf:
innodb_large_prefix = ON
innodb_file_format = barracuda
innodb_file_per_table = ON


And some other steps that are "even more experimental". 😀

https://docs.nextcloud.com/server/12/admin_manual/configuration_database/mysql_4byte_support.html

https://mariadb.com/kb/en/library/xtradbinnodb-file-format/

Phew! Everything is still working. 😀

#mariadb #innodb #barracuda