I have an old problem using the single quote (') character in text field
because Postgresql thinks it is the "end of text" character. The '
characther is used a lot in my language. As a workaround I'm parsing the
fields duplicating the ' characters inside the text but this is a bad
Assuming field1 and field2 are text field, as I usually use in my
programs something like :
sprintf (auxstr, "SELECT field WHERE field=%s AND field2=%s" , vartext1,
As vartext1 and vartext2 can contain the ' so I need to create char[size]
variables to save the output of my "duplicate ' characters" function.
DuplicateSingleQuote (OriginalText1, vartext1); //vartext1 is the new
valid text to insert
So the code is full of temporary chart variables.
Is there any way to change the start/end of Text field character or do you
know a better workaround to avoid parsing/changing all the text fields just
in case they contain the single quote ( ') character??.