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 ?
