German Character in the files
Moderators: chulett, rschirm, roy
German Character in the files
Hello Sirs,
In my German input file i have some german characters ,so i did is i used
NLS ISO 8859-1 for the input file i did some process i write into a filex
with project default NLS upto this point everything...
But when i write into ODBC Stage (Database) the job was aborted...
please help me on how to handle these special characters.
Thanks
Narasa
In my German input file i have some german characters ,so i did is i used
NLS ISO 8859-1 for the input file i did some process i write into a filex
with project default NLS upto this point everything...
But when i write into ODBC Stage (Database) the job was aborted...
please help me on how to handle these special characters.
Thanks
Narasa
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 130
- Joined: Mon Sep 06, 2004 3:05 am
- Location: Dubai,UAE
German Character in the files
Hi Reddy,
We had a similar problem when we were trying to load data to SAP for Norwegian Characters.
Using NLS UTF-8 had resolved it.
We had a similar problem when we were trying to load data to SAP for Norwegian Characters.
Using NLS UTF-8 had resolved it.
Warm Regards,
Amruta Bandekar
<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
Amruta Bandekar
<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
I've got to side with Wolfgang here. The only German character that can conflict (when not using NLS) is the u-umlaut as that maps to either a @VM or @FM (cannot recall which one). If you are doing explicit mapping from one character set to another then the most likely error you are going to get is that DS tells you that it cannot map a character, but this doesn't usually happen within the 1-byte Latin-1 character set.
What error is the ODBC driver giving you?
What error is the ODBC driver giving you?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
The file-viewer in Datastage is most likely converting the character to a "?", where are you displaying this from - and if you are using a database utility, make sure that it's display attributes set via the environment variables are set correctly (see if other tables show German characters correctly in the same tool, or create a test table and enter and then display a text with umlaute).
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi,
In my database table umlaut is entered and displyaed correctly....Its just that when I try to store the data into a CSV file...it is not dislpyaed correctly...do i have to do something in the job...but if i manually save the target file as UTF8 instead of ANSI, I am able to see it correctly in DS job as well.
Saad
In my database table umlaut is entered and displyaed correctly....Its just that when I try to store the data into a CSV file...it is not dislpyaed correctly...do i have to do something in the job...but if i manually save the target file as UTF8 instead of ANSI, I am able to see it correctly in DS job as well.
Saad
saadmirza - in DS you can explicitly set the output file format in the output CSV file, I guess this is what you are doing as you say you can view the data. What is your input database and what are your NLS settings for that source stage?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Saadmirza - if this continues it would be best to open up a new thread, or else we'll be accussed of thread-hijacking. In your case, read from Oracle and write the data straight back to Oracle unchanged. Is your input and output data identical? Reading your earlier post, it seems that you are saying that when you write to a UTF-8 sequential file from your UTF-8 database everything gets displayed correctly, but if all you do is change your sequential file format to {some other set} the data gets displayed as "?". What is the other convention that you specify? "ANSI" doesn't exist in my maps.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>