网站设计 视频,win10最强优化软件,东莞人才市场招聘会,编程型网页制作工具mysql: utf-8字符集oracle: Al32UTF8步骤#xff1a;1. 从mysql导出csv格式数据#xff0c;导出时设置default_character_setgbk#xff0c;否则会乱码2.上传至linux服务器(oracle服务器),用以下命令将windows的/r/n换成/r:sed -i s//r//g file3.将gbk编码转为u…mysql: utf-8字符集oracle: Al32UTF8步骤1. 从mysql导出csv格式数据导出时设置default_character_setgbk否则会乱码2.上传至linux服务器(oracle服务器),用以下命令将windows的/r/n换成/r:sed -i s//r//g file3.将gbk编码转为utf8编码iconv -f gb18030 -t utf-8 file1.txt file2.txt4.编写sql loader控件文件(file.ctl)options (skip1)load dataCHARACTERSET AL32UTF8infile terminal.txtbadfile terminal.errdiscardfile terminal.disreplace into table terminalfields terminated by , TRAILING NULLCOLS(id,mobile,imsi,imei,evoketime date yyyy-mm-dd hh24:mi:ss,province,city,evokenum,createtime date yyyy-mm-dd hh24:mi:ss,project_id,carrier,ip,sc,new_imsi,new_imei)5. 运行sqlldr导入到oracle数据库sqlldr user/passdb -controlfile.ctl
