MySql Default CHARSET and COLLATION

Опубликовано: 05 Июнь 2026
на канале: The Flask
4,267
29

🙏 Please consider SUBSCRIBING !!! 🧧 Patreon Donations:   / theflask  

Click "SHOW MORE" below to see the cool guides !!! 😎

Checking Default MySql CHARACTER SET and COLLATION

References:
https://stackoverflow.com/questions/8...
https://dev.mysql.com/doc/refman/5.7/...

Check MySql Client Version (the client program) and Distribution

"Ver" - refers to the version of the mysql command line client
what you are envoking by typing 'mysql' or the terminal program.

"Distrib" - refers to the mysql server version your client was built with.
"The package distribution of" for example a Python program or a
C program. This is not the actual MySql Database.

$ mysql -V

-- show MySql's actual version
SELECT VERSION();

-- check current database settings:
SHOW VARIABLES;

-- check CHARACTER SET and COLLATION on MySql:
SHOW VARIABLES LIKE 'character%';
SHOW VARIABLES LIKE 'collation%';

🙏 Please consider SUBSCRIBING !!! 🧧 Patreon Donations:   / theflask  

DISCLAIMER:
All product and company names are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Use of MySQL Conditional Use Logos:
https://bit.ly/3iwhu4I