Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#22 Error with single quotes when substituting CHAR args

open
nobody
None
5
2009-01-23
2009-01-23
No

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'

Discussion