Arabic Language support in out to database

akassem

Hi,

Currently I need to transfer Arabic data from an Oracle database to another database using Alteryx designer

both databases character sets are "AR8MSWIN1256" which of course supports Arabic

the problem is that in order to read Arabic text into Alteryx I have to mark the "Force SQL W Char Support" in the input tool

which forced text conversion into Unicode. (conversion is done correctly)

once data is converted I can't out it back to the second database as it is now incompatible and shows as question marks.

the only way is to use NVarchar2 in the database which supports UTF16 and yes it shows Arabic correctly

can I out the data encoded back as "AR8MSWIN1256" so that I may use Varchar2 instead of having to switch to NVchar2?

Note: I tried same flow on same databases using Tableau prep and it worked fine

Thank you and best regards

MargaritaW

Hello @akassem 

Good question. What driver version are you using? Can you share a small sample of your data (10+ rows) that you want to write out (after Unicode conversion)? I'd like to test it / try it. Thank you!