topic Re: character substitution in Qlik Replicate

character substitution

fj40wdh — Mon, 25 Apr 2022 11:34:02 GMT

Need help removing non-unicode characters.
Moving data from Oracle to Sql Server, AL32UTF8 to IS01.

I have character substitution in place.

u+a3 -> u+0

(I have all characters substituted except ASCII 32 to ASCII 126)

If I run this query

update table
set field = chr(163):

The data is replicated as a question mark.

If I run this query

update table
set field = nchr(163);

The data is replicated with the character substituted as expected.

Current data is non-unicode, how to I remove non-unicode characters?

Steve_Nguyen — Mon, 25 Apr 2022 17:46:39 GMT

@fj40wdh

there are many article on this see some below:

fj40wdh — Mon, 25 Apr 2022 18:00:50 GMT

Yes, read all of those. Only one really applies to my problem, and the solution is "create a support ticket"

Steve_Nguyen — Mon, 25 Apr 2022 20:15:07 GMT

@fj40wdh , then open a support ticket, do you need any other information on this post?