Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@fj40wdh
there are many article on this see some below:
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
Yes, read all of those. Only one really applies to my problem, and the solution is "create a support ticket"
@fj40wdh , then open a support ticket, do you need any other information on this post?