hai guys Any update on thisSreekanth
I will throw in my 2 cents, which may not be much on this ...How did you take a "look" at the data in TD ?In the past I have seen folks complaining about seeing junk, when in reality their PC didn't had the right scripts installed to see it.Can you check that in your control panel / regional language settingson the language tab, the check boxes under the supplemental language is checked ?Also can you copy paste an Arabic character from the windows Charmap utility into a word document and still see it (no-junk) ?Can you do a fast export of the data and try opening it in MS-Office Word ? (use the same font as in charmap)Your problem could be something else, but in case if it helps ...
Hi, Thnx for the update. When i did set the font as @Arial Unicode MS i could view the data.Thanks & RegardsSreekanth
Hi,
I am facing a similar issue while processing arabic text. In fact I have to process text files containing arabic text. The default file encoding is ASCII, I convert it into UTF8, that is fine. The data is loaded, but I can see only garbage. If anyone hav faced this issue, please guie!
Khurram
Khurram
If I remember correctly, there are ODBC properties and change the encoding/character set and you can view the resultset in SQL Assistant. Its only the display problem becasue the SQLA is not able to show it properly, the data loaded should be fine.
I will try to see what exactly was changed to see the arabic data, and will let you know if I am able to find it :)
You can verify your loaded data using CLI based connectivity i.e. BTEQ.
Also, about the setting that Qaisar has mentioned .... you need to go to ODBC -> Edit TD connection -> Change 'Session Character Set' from ASCII to UTF8.
-- If you are stuck at something .... consider it an opportunity to think anew.
Hi Frndz, I am trying to load unicode ( Arabic) data from oracle into teradata using Informatica.Instead of the arabic characters i am getting junk characters in the target database.I suppose there is some issue with codepage. There is a table(Ch****ts) under teradata DBC with entries in the same as WIN1256_6A0 , ARABIC1256_0R.In my Oracle database wht shld be the apt codepage that i should use.Is there some other way to identify the codepage set for teradata , something like this (SELECT * FROM V$NLS_PARAMETERS) which we use for oracle? Advice one the above issues would have been helpful. Thanks in Advance