MySQL Forums
Forum List  »  MySQL Workbench

Re: load xml inline not working in mysql workbench
Posted by: Reiner Hickman
Date: April 20, 2016 02:30AM

I've since found the problem: it came from the character set. I needed to specify the character set that corresponds to ISO-8859-1 on the LOAD statement i.e. CHARACTER SET latin1. Some of the tag content contained european characters like é and è and for some reason this caused the parser to ignore the entire input. Now it works!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: load xml inline not working in mysql workbench
518
April 20, 2016 02:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.