请问我在 MySql query browser 中, 只在 script, result 中,打上几个中问字,都全是乱码, 并且在 Tools -> options -> general 里的字体设置,
有几个中文字体选择(如 宋体) 都是乱码显示的,
无奈下删除重新安装, 问题依旧 另外 不用工具,就用cmd ,可以正常显示..不过,这样一来,不方便保存脚本呀 请问,这个乱码是我的问题,还是这个 MySql query browser 本身的问题
解决方案 »
- 50分,MySQL查询异常:Fatal error encountered during command execution。
- EXCEL导出表头数据
- 在MYSQL中,myisam merge heap memory innodb isam这几种表类型有什么区别?
- 求助:C API调MySQL长时间运行会导致连接失败!
- mysql 编程 不能初始化
- 请问有没有哪位大侠知道mysql5的源代码从哪里下载啊!
- 关于mysql存储过程的参数问题
- 关于删除数据库中重复字段的问题
- 100分在线等一个SQL语句!
- 使用set global 某个变量,是mysql 重启就无效了吗
- mysql 「Ungultige Zeigeroperation」 是什么错误?
- 关于乱码
To create a new Script Editor window without loading a script, choose the New Script Tab option from the File menu. If you're experiencing problems with character sets (for example, Spanish accented characters, Russian, or Chinese characters aren't displayed properly), here's some advice: Avoid ANSI encoding in your script files! Rather than using ANSI, always save them in UTF-8 encoding. Watch out when loading script files generated by other tools. They usually save files in ANSI encoding, which in turn means you'll have to open them as ANSI in Query Browser (see the file type combo box in the file open dialog): 它只能正确显示utf-8编码的中文,其它的gb2312,gbk都会是乱码
1: 安装MySQL数据库时候就指定字符集合为gbk或者gb2312,只要数据库中显示正常中文字符的话,页面肯定显示正常,哪来这么多的转换,烦死了!!
2: 指定服务器的 编码 GBK 或者GB23123: 修改安装目录下的 初始化配置文件 my.ini# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="E:/MySQL5/"#Path to the database root
datadir="E:/MySQL5/Data/"# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1 换成 gbk 或者 gb2312# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB