進入命令行模式，

如果MySQL數據庫已經安裝好，可以使用下列SQL命令查看MySQL當前的字符集設置：

mysql>?show variables like ‘character_set_%‘;

+--------------------------+--------------------------------------------------+

| Variable_name | Value |

+--------------------------+--------------------------------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | gb2312 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | D:\wamp2.5\bin\mysql\mysql5.6.17\share\charsets\ |

+--------------------------+--------------------------------------------------+

依次執行：

set character_set_client =gb2312;

set character_set_connection =gb2312;

set character_set_database =gb2312;

set character_set_results =gb2312;

set character_set_server =gb2312;

問題解決！

原文：http://www.cnblogs.com/lqcdsns/p/6880721.html

總結

以上是生活随笔為你收集整理的mysql 视图 字符集_MySQL创建子视图并查看的时候，字符集报错问题的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。