Re: load xml inline not working in mysql workbench
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!
Subject
Views
Written By
Posted
1389
April 19, 2016 08:36AM
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.