简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

Mysql中文乱码问题windows环境下解决_MySQL

WBOY
Release： 2016-06-01 13:33:06
Original
772 people have browsed it

bitsCN.com

Mysql中文乱码问题windows环境下解决

 

最近开发项目中又重新拿起了Mysql,在搭建环境的时候遇到了中文乱码问题。下面我把我的解决方式跟大家分享一下

 

1、通过show VARIABLES like 'character_%'; 显示出来所有的设置项目。把其中的非UTF8的编码都设置成utf8

 

设置方式如 ： set character_set_server=utf8;

 

2、去mysql 安装目录下找到my.ini文件。设置里面的latin1为utf8

 

3、另外如果在Java端通信数据的时候发生了乱码的话就response.setCharacterEncoding("utf-8");

bitsCN.com
Related labels：
windows Chinese development projects
source：php.cn
Previous article：Mysql开源备份工具Xtrabackup备份部署_MySQL Next article：mysql动态新建以及删除分区表_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Compare Imagick, Adobe Photoshop and Windows - Detect resolution (pixels per centimeter or pixels per inch) This is not a question but an attempt to improve my understanding of how DPI is stored in ...
From 2024-04-06 16:01:27
0
1
397
Use locally installed libraries in website pages Is it possible to use libraries (.dll, .ocx) written for Windows operating systems and reg...
From 2024-04-05 00:15:49
0
1
3563
Authserver "Unable to connect" "Host xxxxx is not authorized" after changing the LAN installation IP Use the default Windows installation instructions on a bare metal Windows 10 installation....
From 2024-04-04 15:06:41
0
1
374
/bin/sh: 1: C:xamppphpphp.exe: not found I'm using WSL2, Ubuntu20.04 and running VSCode. I'm using the CodeRunner extension in VSCo...
From 2024-03-31 09:10:37
0
1
333
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！