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

mysql插入中文字符串乱码显示？？？_MySQL

WBOY
Release： 2016-06-01 13:09:53
Original
1020 people have browsed it

对于mysql中文出现乱码解决方法：

1.mysql在建库的时候要确保编码方式为utf-8

2.数据库连接的url要设置编码方式为utf-8

如果数据库的驱动以及url等配置信息放在properties文件中如下设置：database.url=jdbc:mysql://127.0.0.1:3306dbname?useUnicode=true&characterEncoding=utf8
Copy after login

如果直接在xml文件中进行配置，设置如下：<property name="url" value="jdbc:mysql://127.0.0.1:3306/dbname?useunicode=true&characterEncoding=utf8"></property>
Copy after login


source：php.cn
Previous article：分析MySQL数据类型的长度_MySQL Next article：MySQL的rank函数实现_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
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1453
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
9
1618
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1385
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1305
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1357
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！