dongqichang7988 2016-12-31 15:51
浏览 283

无法将Latin1转换为utf-8? 不是编码员

I live in the US, wanting to set up a website using cPanel. I bought a InstaWebsite that's written in Latin1 (England)(this is supposed to be an option in the Character Set of Files list) and need it translated to UTF-8.

I try to import the file “store database.text” and nothing happens but an empty file is created(&Latin1 is not an option). Can anyone help? Are there any easy fixes.

I spoke w/a tech person that hosts my domain on InMotionHosting. I He suggested asking you for help. I don't know how to code. I also sent an email to the fellow I bought this from – he’s in England & am waiting for help from him.

This is what it does when I try to import using UTF-8:

SQL query:

CREATE TABLE `address_book` (
`address_book_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` INT( 11 ) NOT NULL DEFAULT '0',
`entry_gender` CHAR( 1 ) NOT NULL DEFAULT '',
`entry_company` VARCHAR( 32 ) DEFAULT NULL ,
`entry_firstname` VARCHAR( 32 ) NOT NULL DEFAULT '',
`entry_lastname` VARCHAR( 32 ) NOT NULL DEFAULT '',
`entry_street_address` VARCHAR( 64 ) NOT NULL DEFAULT '',
`entry_suburb` VARCHAR( 32 ) DEFAULT NULL ,
`entry_city` VARCHAR( 32 ) NOT NULL DEFAULT '',
`entry_state` VARCHAR( 32 ) DEFAULT NULL ,
`entry_postcode` VARCHAR( 10 ) NOT NULL DEFAULT '',
`entry_country_id` INT( 11 ) NOT NULL DEFAULT '0',
`entry_zone_id` INT( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id` ( `customers_id` )
) TYPE = MYISAM AUTO_INCREMENT =100;

MySQL said:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=100' at line 17

  • 写回答

1条回答 默认 最新

  • drvvepadi289421028 2016-12-31 19:23
    关注
    ) TYPE = MYISAM AUTO_INCREMENT =100;
    

    This code is incorrect. If you got this SQL file as part of a software package you bought, get a refund -- it's obviously an untested piece of junk.

    The proper way to specify a storage engine for a MySQL table is using the ENGINE option:

    ) ENGINE=MyISAM AUTO_INCREMENT=100;
    
    评论

报告相同问题?

悬赏问题

  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)