View Issue Details

IDProjectCategoryView StatusLast Update
0005592OXID eShop (all versions)7. --- Other tools --------------public2017-04-04 14:31
Status confirmedResolutionopen 
Product Version4.8.2 / 5.1.2 
Target VersionFixed in Version 
Summary0005592: SQL importer doesn't work correctly when parsing UTF-8
DescriptionWhen trying to import an UTF-8 SQL file via admin -> service -> tools, the import fails with the error message "You have an error in your SQL syntax; check ...
Error number : 1064".
This is obviously because the OXID multibyte functions are not used in this tool.
Additional Information
TagsSQL, UTF-8
ThemeNot defined
PHP VersionNot defined
Database VersionNot defined



2014-01-07 18:50

reporter   ~0009387

I want to add some details:
It not directly depends on the UTF-8 mode of the SQL-Data, but the HTML-Form of the service tool (which runs with UTF-8 in most cases). I've build a SQL test snippet which reproduces the error (the same with "ä", "ö", "ü"):

INSERT IGNORE INTO oxcontents (oxid,oxloadid,oxtitle,oxcontent)
VALUES('test','test','test','some text including "ß"...');
DELETE FROM oxcontents WHERE oxid='123test';

Both statements for their own are running fine, but together it gives an error because str_len() is counting wrong so that the ";" isn't correctly matched as a seperator for the statements I guess.