Unanswered: How do I get a single quote into a VARCHAR field?
I have the Problem, that I want to put a _'_ single quote into a varchar field.
Because I have to put the text for the field into single quotes, the one inside my text, breaks the statement.
I tried to put the text into _"_ double quotes but that produces an odd error message.
There are a lot of textfields I have to fill with my statement and all the other got single quotes around their values only the one field that has to contain a text with a singel quote in it was surroundes with double quotes.