Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

MySQL导出CSV中文乱码 如何还原?

WBOY
Release： 2016-06-06 20:24:26
Original
1204 people have browsed it

如图所示,打开的中文乱码了,有办法还原吗?数据库是UTF-8的
直接用notepad++打开的也是乱码,CSV文件是UTF-8格式的。
我没办法操作数据库,所以无法再去导出。

MySQL导出CSV中文乱码 如何还原?

MySQL导出CSV中文乱码 如何还原?

回复内容：

如图所示,打开的中文乱码了,有办法还原吗?数据库是UTF-8的
直接用notepad++打开的也是乱码,CSV文件是UTF-8格式的。
我没办法操作数据库,所以无法再去导出。

MySQL导出CSV中文乱码 如何还原?

MySQL导出CSV中文乱码 如何还原?

用记事本打开,选择编码格式为ANSI，另存为新的CSV文件

Excel是用GBK的，Notepad++可以选择编码格式 “以ANSI格式编码”就可以了

Related labels：
mysql php
source：php.cn
Previous article：用户表和用户信息表，为什么要分两个表呢，一般都是什么字段呢？ Next article：缓存 - PHP上传文件到云存储服务中，到底是占用了谁的带宽？
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
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
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