-
1. Re: sql import script executes incorrectly between '/' characters
gerry.matte Aug 1, 2013 2:09 AM (in response to akshayv)I've always had trouble trying to store URL strings into a mysql database ..... Retrieval by a search query is also problematic.
Try using URLEncoder to convert a URL string to a more useable format before inserting it into mysql.
You'll also need URLDecoder most likely.
I've avoided the problem for data columns if I can strip off the http:// characters but increasingly URLs are using https:// and reconstructing the full URL is then a problem.
-
2. Re: sql import script executes incorrectly between '/' characters
bmajsak Aug 29, 2013 6:56 AM (in response to akshayv)Hi Akshay,
the problem might be that // is in some engines treated as comment and APE is stripping comments before executing any SQL script. If you can execute this script against your DB directly then it's obviously a bug on my side. Would be so kind and file Jira ticket if that is the case?
Cheers,
Bartosz