How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

MySQL Import with SQL containing HTML entities fails

[This topic is migrated from our old forums. The original author name has been removed]

Hi, I'm trying to insert data into mysql that contains HTML entities, e.g.:   The text is escaped / quoted so it should be fine. When running the insert SQL in DBVis I get an error on each ';', but if I use the command line mysql tools to run the script everything works fine. Is there a setting I need to apply in DBVis to get it to handle the entities? Thanks Darren.
1 Comment
[This reply is migrated from our old forums.]

Re: MySQL Import with SQL containing HTML entities fails
Hi Darren, Can you please show a complete example? If the text containing the semicolon is indeed within single or double quotes, it should work fine, so I need more infer to figure out what's going on. If you can attach a simple script that reproduces this, it would be great, as the forum tends to "eat" HTML code. Best Regards, Hans
Comments to this discussion are now closed!
More topics in Support
See all 1297 topics