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

MySQL刷库脚本中带中文

WBOY
Release： 2016-06-07 17:13:54
Original
1163 people have browsed it

MySQL刷库脚本中带中文，用MySQL命令登录后刷入数据库后，读取出来出现乱码。

MySQL刷库脚本中带中文，用MySQL命令登录后刷入数据库后，读取出来出现乱码。

出现的情况有可能是下面的原因：

安装完MySQL没有修改客户端连接编码，，默认是latin1，用MySQL命令登录进去直接source,导致刷进去的数据是latin1编码的。

解决方案：

1.MySQL命令登录时加参数

2.修改my.cnf（目录在/etc/my.cnf）,在[client]增加如下代码

 

 

 

linux

Related labels：
database
source：php.cn
Previous article：Hibernate 查询结果的展现 Next article：数据库的逻辑备份和物理备份--非RMAN
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
WordPress 6.0 (add_editor_style) does not load style.css in Gutenberg editor I'm taking the UdemyWordPress course to create a custom WordPress block theme. I successfu...
From 2023-11-12 20:37:50
0
2
261
What is the alternative to pages/_app.js in Application Router in NextJS? I've just started using NextJS and there is a new router called Application Router. Now I ...
From 2023-11-11 09:38:14
0
1
395
Vue, vite: GET http://localhost:3000/@vite/client The title of net::ERR_ABORTED 404 (Not Found) is rewritten to: Vue, vite: on http://localhost:3000/@vite/client A net::ERR_ABORTED 404 (not found) error occurred in the initiated GET request. I'm using Vue and vite to practice the workflow of a web application that uses an API to g...
From 2023-11-06 11:49:11
0
2
255
Rewrite the title as: Passing array of integers to MySQL stored procedure I want to create a stored procedure which receives an array of integers and some other inp...
From 2023-11-03 10:46:21
0
2
179
Vuejs - Breakpoints not set in VSCODE I'm trying to debug vuejs using vscode, I've tried many tutorials/answers but can't get it...
From 2023-11-02 15:53:39
0
2
292
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！