|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
IP: 112.84.200.44
2016-09-18, 12:30 PM
|
|||
|
|||
mysql load data 乱码的问题
新学mysql在用load data导入txt文档时发现导入的内容，select 之后是乱码，先后把表，数据库的字符集类型修改为utf8,但还是一样，最后发现问题，导入的文档不是utf8类型的。
load data local infile 'c:\\data.txt' into table person2 character set utf8 (name,age,city,salary); 这个是导入到表person2，语句的默认分隔符是tab 
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| CentOS6.5和RedHat6.5下以rpm方式安装mysql-5.6.20 | Olivette | MySQL | 0 | 2016-05-20 07:30 AM |
| MySQL毫秒值和日期的指定格式的相互转换 | Kaitlin | MySQL | 0 | 2015-04-18 11:01 PM |
| mysql 帮助文档使用 | Haddam | MySQL | 0 | 2014-11-26 06:43 PM |
| mysql安装与简单使用 | sunshine | 服务器环境搭建 | 0 | 2006-01-11 07:29 PM |
| winxp下安装全新的apache,php(5.0),mysql(5.0)... | topvip | 服务器环境搭建 | 0 | 2006-01-08 10:28 PM |
Threaded Mode