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) writes:
|>
|>
|> 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
|>

yes, use oracle convert function works something like this

     select convert(column,WE8EBCDIC500)
     from table

see sql language refrence for function refrence. NOTE: This is Oracle7 feature

Prabhakar Received on Sat Aug 20 1994 - 00:28:51 CEST