Page 1 of 1
Posted: Wed Mar 12, 2008 3:56 am
by ArndW
I would suggest keeping the problem simple. How are you converting the EBCDIC to ASCII in your jobs? What version of EBCDIC do you have (there are several)?
Posted: Fri Mar 14, 2008 3:21 am
by ArndW
PhilHibbs wrote:Those characters don't exist in ASCII...
Hmmm... sort of; the first 7-bit implementation of ASCII did not have any of the extended characters, but 8-bit ASCII with the diacritics and other characters has been around as an ISO standard (ISO646) since 1972 and today "ASCII" is pretty much synonymous with the extended 8 bit representation.
Nevertheless your mail is spot-on in that the original poster needs to know which EBCDIC representation is being used and which character set it is being converted to.
Retraction - I just checked up on Wiki and see that official "ASCII" indeed remains as a 7-bit encoding and thus the diacritics and special characters are
not part of ASCII. Thanks for the pointer!
Posted: Tue Mar 18, 2008 12:56 am
by jenny_wang
actually I have 4 columns have those diacritics characters, and I am not sure how many different diacritics characters will be used in the column.
does that mean if I wanna convert those characters correctly, first I must enable NLS,then code as PhilHibbs post to replace all diacritics characters with Unicode characters?
Thanks for help!
Posted: Tue Mar 18, 2008 12:59 am
by jenny_wang
actually I have 4 columns have those diacritics characters, and I am not sure how many different diacritics characters will be used in the column.
does that mean if I wanna convert those characters correctly, first I must enable NLS,then code as PhilHibbs post to replace all diacritics characters with Unicode characters?
Thanks for help!
Posted: Tue Mar 18, 2008 3:25 am
by ArndW
If you don't have NLS enabled this EBCDIC to ASCII conversion should work. Can you narrow it down to one character in EBCDIC and show the numeric value in EBCDIC and then the value after it is converted to ASCII?
Posted: Tue Mar 18, 2008 6:11 am
by ArndW
I played around in Server and had the same issues with the characters in the upper range of ASCII.
Have you tried to see what happens when the FTP program takes care of the conversion from EBCDIC to ASCII - it might handle the characters appropriately.
Finally, you might have to revert to what Phil has already posted above.
Posted: Tue Mar 18, 2008 7:38 am
by gmt_etldev
one question:
if i don't enable NLS, can I do what as PhilHibbs post?
Posted: Tue Mar 18, 2008 8:07 am
by ArndW
Yes, but you can use the CHAR() function and drop the multibyte character.
Posted: Wed Mar 19, 2008 12:13 am
by jenny_wang
I tried char(),but the DS can't recognize the 8-bit ascii, so I must enable the NLS and set the mapping character set as "ISO8859-1+MARKS", right?
Thanks!
Posted: Wed Mar 19, 2008 2:01 am
by ArndW
No, you don't need to enable NLS. Could you explain your problem with the CHAR() function - I don't see it having a problem with the full ASCII set.
Posted: Sun Mar 23, 2008 9:07 pm
by jenny_wang
please help!