#247 Error in query: Incorrect string value: when importing

3.3.4
closed-invalid
nobody
None
5
2012-06-29
2012-05-26
wes
No

Receive "Error in query: Incorrect string value: '\xF1\xEDa Do...' for column 'isp' at row 1" when executing the following SQL command from admin.sql file:

INSERT INTO `iplocationdb_isp` VALUES(64,1075855360,1075871743,"Compañía Dominicana de Teléfonos, C. por A. - CODE");

The command works fine when executed from the SQL Command input box.

Adminer 3.3.4

MySQL version: 5.5.24 through PHP extension MySQLi

Table iplocationdb_isp is defined as:

Column Type Comment
prefix tinyint(3) unsigned
start_ip int(10) unsigned
end_ip int(10) unsigned
isp varchar(64)

Discussion

  • Jakub Vrána

    Jakub Vrána - 2012-06-29
    • status: open --> closed-invalid
     
  • Jakub Vrána

    Jakub Vrána - 2012-06-29

    The file probably starts with UTF Byte-Order-Mark. Save it without this mark, Adminer doesn't support it.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks