double up quotes (apostrophe)
Hello
I have a variable which contains a french string with a quote: L'experience....
This string could come from XML-File, text file or error messages.
How is it possible to double up the single quote to insert this string into a database?
A simple insert fails because the database does not accept this:
INSERT INTO xxx VALUES(#variable_name)
I found a technical document for ODI: ID 867906.1 but this document does not explain how to double up.
Any hints are appreciated.
Regards
Markus