Arabic language support when copying data from Sybase to Orace

One Star

Arabic language support when copying data from Sybase to Orace

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
One Star

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

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

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

Hello
Can you get the correct result when you use a tLogRow to print the data on console?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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 Smiley Happy
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 ???
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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

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

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

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

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

Hello Enami,
My connection string looks like this
jdbcSmiley Surprisedracle: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