Re: Are there any ways to convert EBCIDIC to ASCII columns

In article <9408181128.PN28951_at_LL.MIT.EDU>, forgy_at_ll.mit.edu (James Forgy) wrote:

> Does anyone know of a function or a way to convert an Oracle EBCIDIC
 column to
> its ASCII equivalent? Maybe a public domain decode statement or
> something...any FTP sites.
>
>
> -jf
Why that? What do you need it for?
If you want transfer your Oracle data from an IBM host to an ascii host   you can simply use export (on the EBCDIC machine) and transfer   your export file in binary mode to the ascii machine and do there   an import. Oracle is smart enough to do the translation for you.   If you set the correct NLS_LANG environmet prior to the exp and   imp, you get even the characters above ascii(127) correct translated. If you want to bring text files from one host to the other, then   use your preferred filetransfer program (in FTP use ascii mode). If you want to know what is what, then you can get a translation   table, e.g.
  dec hex EBCDIC ASCII

    0   00  NUL     NUL
    1   01  SOH     SOH
    2   02  STX     STX
    3   03  ETX     ETX
    4   04  PF      EOT
    5   05  HT      ENQ
    6   06  LC      ACK
    7   07  DEL     BEL
    8   08          BS
    9   09          HT
   10   0A  SMM     LF
   11   0B  VT      VT
   12   0C  FF      FF

-- 
Leo Mannhart
Planning Office
University of Zurich           phone: ++41 1 257 23 34
Kuenstlergasse 15                fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland    eMail: mannhart_at_zuv.unizh.ch