PrecisionSQLHow to Prevent UTF8MB4 From Truncating Indexes
Long utf8mb4 keys can exceed index limits.
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
UTF8MB4 Emoji Support EXPLODES Table From 500GB to 2TB?! #sqlshorts
ルモーリン久しぶりに自分のホームページを更新。
ＭｙＳＱＬにあるｕｔｆ８ｍｂ４、この「４」が実際に見られるようサービスを改良しました。
こちらのサービスで絵文字を入力するとｕｔｆ８の４バイトが見られます。
絵文字のバイト列を表示する世界唯一のサービスです・・・とか言っとけば親切な人が先駆者を教えてくれるハズ。 #utf8 #utf8mb4 #fedibird
絵文字を含む文字列を分割 - サービス - ルモーリン https://www.lemorin.jp/service/0e_split_char.html
ＭｙＳＱＬにあるｕｔｆ８ｍｂ４、この「４」が実際に見られるようサービスを改良しました。
こちらのサービスで絵文字を入力するとｕｔｆ８の４バイトが見られます。
絵文字のバイト列を表示する世界唯一のサービスです・・・とか言っとけば親切な人が先駆者を教えてくれるハズ。 #utf8 #utf8mb4 #fedibird
絵文字を含む文字列を分割 - サービス - ルモーリン https://www.lemorin.jp/service/0e_split_char.html
zartomHow 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/
...
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/
...
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/
...
Matt
me·ta·phil, der
Doughnut Lollipop 【記録係】
Steffen K9 🐰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:
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
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 = ONAnd 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