資料庫編碼
取得資料庫編碼
use <DATABASE_NAME>
SELECT @@character_set_database, @@collation_database;
SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '<DATABASE_NAME>';
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;