Input Tool, special characters replaced for CLOB column in DB

[rp19]

I've a Clob column in a database table which has special characters e.g "(double quotes) and '(single quotes)
When I input them in Alteryx via Input tool or IN-DB tool these get replace by blanks or?(question mark character)

----------Sample text----------------

Input in DB - Hell’o “How”are you’
Input in Alteryx - Hell?o How?are you?
---------------------------------------

I've already tried checking "Force sql w char support", but it results in an error m_OCILobRead Error: ORA-24806: LOB form mismatch.
I've also tried changing the encoding from Localization to Unicode UTF-8, but this also doesn't solve the error.

Is there any way I can retain special characters as it is ?

[rp19]

accepted