topic Re: Arabic language support when copying data from Sybase to Orace in Talend Studio

Arabic language support when copying data from Sybase to Orace

Anonymous — Sat, 16 Nov 2024 13:49:40 GMT

Dear Brothers
i have a problem in arabic language support , when i do copying from Sybase DB to Orace DB
when i copied arabic data from sybase table to oracle table , i would get the arabic words like (????)
i uplloaded the images which are showing the connections i used for both Sybase and Oracle
Thanksss

Re: Arabic language support when copying data from Sybase to Orace

Anonymous — Thu, 13 Aug 2009 09:15:08 GMT

and there another question brothers
can i modify the source code ??

Re: Arabic language support when copying data from Sybase to Orace

Anonymous — Fri, 14 Aug 2009 09:18:26 GMT

Hello
Can you get the correct result when you use a tLogRow to print the data on console?
Best regards
shong

Re: Arabic language support when copying data from Sybase to Orace

Anonymous — Sun, 16 Aug 2009 10:42:10 GMT

Hello
Can you get the correct result when you use a tLogRow to print the data on console?
Best regards
shong

ok shong,
i solved this issue
i put concatenate this string ("?charset=cp1256") to my connection string , and it worked fine , so i got my arabic data correctly after copying ,
but when i added or removed any component , i lost my updated string
is there away to keep my connection string without change ???

Re: Arabic language support when copying data from Sybase to Orace

Anonymous — Mon, 17 Aug 2009 03:00:05 GMT

Hello

but when i added or removed any component , i lost my updated string
is there away to keep my connection string without change ???

Define a global context group to store the connection parameters and import these context vars in each job.
Best regards

shong

Re: Arabic language support when copying data from Sybase to Orace

Anonymous — Thu, 04 Feb 2010 11:30:16 GMT

Hi, I m facing the same problem, Where did you put ?charset=cp1256 in the connection string .. I mean from which screen..

Re: Arabic language support when copying data from Sybase to Orace

Anonymous — Sun, 07 Feb 2010 05:07:35 GMT

Hi Talend Team,
Is there any solution to this problem?.....

Re: Arabic language support when copying data from Sybase to Orace

Anonymous — Sun, 07 Feb 2010 07:24:59 GMT

Hi,
Putting "?charset=cp1256" in the database field of sybase connection
or
SID field if you are using repository sybase connection
.......worked for me.
Don't forget to set NLS_LANG to AMERICAN_UNITED ARAB EMIRATES.AR8MSWIN1256
in the following registry keys
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE0
use regedit
Best Regards,
Amin

Re: Arabic language support when copying data from Sybase to Orace

Anonymous — Wed, 30 Apr 2014 16:06:10 GMT

Hello Enami,
My connection string looks like this
jdbc racle:thin:@(description=(address=(protocol=tcp)(host=krdh-scan-ip.konesdc.gov.in)(port=1531))(connect_data=(service_name=krdh_app)))
where can I add charset UTF8..
please email me urgent at sangeet171188@gmail.com