Menu

#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


Log in to post a comment.