how to use JDBC request when parameters have "

[DrLuRen]

The documentation URL

https://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request

Feedback

I try to make a JDBC request update user set nickname = ? where id = ?

Parameters is ${nickName},${id}

Beanshell is String nickname = vars.get("nickname"); log.info("before ===>" + nickname); nickname = nickname.replaceall("\"","\"\"\""); log.info("after ===> "+ nickname); vars.put("nickname",nickname);

but I get a error

before ===> nick"name after ===> nick"""name cannot have quote-char in plain filed:[nick"]

the document say

The list must be enclosed in double-quotes if any of the values contain a comma or double-quote, and any embedded double-quotes must be doubled-up, for example: "Dbl-Quote: "" and Comma: ,"

how to make it work?