以下是檢查特定 MySQL 數(shù)據(jù)庫的默認(rèn)字符集的查詢 –
mysql> SELECT SCHEMA_NAME 'DatabaseName', default_character_set_name 'Charset' FROM information_schema.SCHEMATA where schema_name = 'db_name';
登錄后復(fù)制
示例
例如,下面的查詢將返回名為“Sample”的數(shù)據(jù)庫的默認(rèn)字符集 –
mysql> SELECT SCHEMA_NAME 'DatabaseName', default_character_set_name 'Charset' FROM information_schema.SCHEMATA where schema_name = 'Sample'; +----------------+---------+ | DatabaseName | Charset | +----------------+---------+ | Sample | latin1 | +----------------+---------+ 1 row in set (0.00 sec)
登錄后復(fù)制
以上就是我們?nèi)绾尾榭刺囟?MySQL 數(shù)據(jù)庫的默認(rèn)字符集?的詳細(xì)內(nèi)容,更多請關(guān)注www.92cms.cn其它相關(guān)文章!