因为纯真不支持模糊查询,所以想把纯真数据库导入到MySQL,结果有些数据没有导入成功..求解~

19658

  • [2012-11-17 12:21:00] Import start
  • [2012-11-17 12:21:00] Import type - Excel2007 file
  • [2012-11-17 12:21:00] Import from - C:\Users\Administrator\Desktop\3.xlsx
  • [2012-11-17 12:21:00] Import table
  • [2012-11-17 12:21:05] 1366 - Incorrect string value: '\xE7\xA1\x9A\xE5\x8F\xA3...' for column 'Address' at row 2
  • [2012-11-17 12:21:05] INSERT INTO ip (BeginIP,EndIP,Address) VALUES ('58.48.1.26','58.48.1.211','湖北省武汉市武昌区 电信'),('58.48.1.212','58.48.1.212','湖北省武汉市硚口区 古田二路聚友网吧'),('58.48.1.213','58.48.3.255','湖北省武汉市武昌区 电信'),('58.48.4.0','58.48.5.255','湖北省武汉市 (硚口区)电信ADSL'),('58.48.6.0','58.48.15.255','湖北省武汉市 电信'),('58.48.16.0','58.48.16.255','湖北省武汉市 (汉阳区)电信ADSL'),('58.48.17.0','58.48.23.248','湖北省武汉市 电信'),('58.48.23.249','58.48.23.249','湖北省武汉市 中青网络家园宇光店'),('58.48.23.250','58.48.23.255','湖北省武汉市 电信'),('58.48.24.0','58.48.24.255','湖北省武汉市江岸区 电信'),('58.48.25.0','58.48.25.250','湖北省武汉市 电信'),('58.48.25.251','58.48.25.251','湖北省武汉市 二七涵洞纤颖力网吧'),('58.48.25.252','58.48.26.255','湖北省武汉市 电信'),('58.48.27.0','58.48.27.255','湖北省武汉市 (江岸区)电信'),('58.48.28.0','58.48.32.62','湖北省武汉市 电信'),('58.48.32.63','58.48.32.63','湖北省武汉市武昌区 魔力贝贝网吧(晒湖小区12栋1-2单元)'),('58.48.32.64','58.48.41.220','湖北省武汉市 电信'),('58.48.41.221','58.48.41.221','湖北省武汉市 沌口泰合百花园')
  • 以下省略N千行.....复制代码

19659