character substitution

[fj40wdh]

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]

@fj40wdh

there are many article on this see some below:

https://help.qlik.com/en-US/replicate/November2021/Content/Global_Common/Content/SharedEMReplicate/C...

https://community.qlik.com/t5/Knowledge/Example-of-using-Character-Substitution-in-Replicate/ta-p/19...

https://community.qlik.com/t5/Knowledge/Replicating-special-characters/ta-p/1915507

https://community.qlik.com/t5/Qlik-Replicate/Non-unicode-characters/m-p/1718432

[fj40wdh]

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

[Steve_Nguyen]

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