Why are information_schema and performance_schema not utf8mb4 (and should I care)?
I have been going through my MariaDB installation with a fine-toothed comb trying to update everything from utf8 (3-byte flavor) to utf8mb4. It's correct in my.cnf, all my databases, and all applicable tables and columns thereof. And when I create new databases with no options, it does create them with the correct collation. But see this screenshot of Adminer - two of the three infrastructure databases are still utf8. Is this okay? If not, how should I change them? This server isn't live yet, but it's very close to ready, so I'd rather not do something stupid and break the DB engine.
Do not change anything in mysql, performance_schema, or information_schema.
Beware of any indexed VARCHAR(255) CHARACTER SET utf8 -- they will have trouble with a limit of 767 bytes on the index.
- Duplicate key error after adding data in a table with seeded entities
- Get count of id for each day and Group by date
- How can I replace a string in a MySQL database for all tables in all fields in all rows?
- Run sql file in database from terminal
- What is the best way to do incremental backups in MySQL?
- How do I set MyISAM as default table handler in MySQL?
- Sequilize query is returning only one row while using include
- MySQL Error: #1142 - SELECT command denied to user
- MySQL Not Equal To Certain Length
- How to disable secure_file_priv in MySQL 8.0 in windows 10 machine?
- Php mysql query update of data gives syntax error
- How to retrieve a lot of data in my asp .NET app efficiently?
- Update an existing sql table based on content from an external csv file?
- Error: select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'
- winMySQL query fails on Ubuntu instance but works with Windows instance
- How to connect from VSCode to a mysql docker container?
- SQL syntax error when trying to create a new table using TypeORM
- How do I convert text entered in form to Title Case Using PHP before submitting to MySQL?
- How to declare a variable in MySQL?
- MySQL Paging and Return Total
- How to drop columns in a table, where column names are "index" and " Unnamed: 0" in mysql
- How to deal with enormous line lengths created by mysqldump
- MySQL union - alias not visible
- Join newest price from price-table for all products
- Mysql ERROR: ASCII '\0' while importing sql file on linux server
- User registration with CodeIgniter
- Paging Results: Handling invalid passed data
- I'm stuck with foreign key constraint fails error. .NET 8, EF Core 8.0.2
- find number of rows in returned mysql result (nodejs)
- Get records that have total count of over X amount