如何使用PHPmyAdmin找出数据库和表的字符集? [英] How to find out the charset of a database and table with PHPmyAdmin?

问题描述

PHPMyAdmin中是否可以找到表和/或数据库的字符集?

Is there a way in PHPMyAdmin to find out the charset of a table and/or a database?

唯一显示的是排序规则.但是据我了解，排序规则仅告诉数据库如何比较数据，而字符集则告诉数据库如何存储数据.

The only thing that ist shown, is the collation. But as far as I understood, the collation only tells the database how to compare the data, and the charset tells the database how to store the data.

推荐答案

尝试编写SQL命令:

SELECT * FROM information_schema.SCHEMATA S
WHERE schema_name = "myDataBase";

您可能要检查此内容的评论资源;

You might want to check this answer and the comments on this ressoure;

这篇关于如何使用PHPmyAdmin找出数据库和表的字符集?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！