最佳答案
如Server Character Set and Collation所述:
Initially,the server character set and collation depend on the options that you use when you start 07001. You can use 07002 for the character set. Along with it,you can add 07003 for the collation. If you don’t specify a character set,that is the same as saying 07004.
因此,默认服务器字符集是Windows-1252,MysqL调用latin1,除非您的MysqL副本已经使用其他一些默认编译.
手册继续说:
The current server character set and collation can be determined from the values of the 07005 and 07006 system variables. These variables can be changed at runtime.
因此,要发现当前使用的服务器字符集:
SHOW VARIABLES LIKE 'character_set_server'