Error with single quotes when substituting CHAR args
Brought to you by:
perdom
When a string is provided as an argument, then in the SQL with the arguments substitued, the string is delimited by two single quotes and single quotes within the string remain are not escaped. For example:
"my 'example' string"
is shown as
''my 'example' string''
instead of
'my ''example'' string'