Re: Loading EBCDIC binary file into a UNIX environment

Good idea.

I have a similar problem: I want to convert my surnames containing German umlauts, Apostrophes etc. into HTML that is displayed nicely. Is there a character set that I can use for that and that will produce things like "&umla;"?

Martin

Buck Turgidson wrote:
>
> See the CONVERT function. Here is a paste from Chapter 3 of Oracle 8 SQL
> Reference. Sorry for the HTML.
>
> Syntax
> CONVERT(char, dest_char_set [,source_char_set] )
>
> Purpose
> Converts a character string from one character set to another.
>
> The char argument is the value to be converted.
>
> The dest_char_set argument is the name of the character set to which char is
> converted.
>
> The source_char_set argument is the name of the character set in which char
> is stored in the database. The default value is the database character set.
>
> Both the destination and source character set arguments can be either
> literals or columns containing the name of the character set.
>
> For complete correspondence in character conversion, it is essential that
> the destination character set contains a representation of all the
> characters defined in the source character set. Where a character does not
> exist in the destination character set, a replacement character appears.
> Replacement characters can be defined as part of a character set definition.
>
> Example
> SELECT CONVERT('Groß', 'US7ASCII', 'WE8HP')
> "Conversion"
> FROM DUAL;
>
> Conversion
> ----------
> Gross
>
> Common character sets include:
>
> US7ASCII
>
> WE8DEC
>
> WE8HP
>
> F7DEC
>
> WE8EBCDIC500
>
> WE8PC850
>
> WE8ISO8859P1
>
> US 7-bit ASCII character set
>
> DEC West European 8-bit character set
>
> HP West European Laserjet 8-bit character set
>
> DEC French 7-bit character set
>
> IBM West European EBCDIC Code Page 500
>
> IBM PC Code Page 850
>
> ISO 8859-1 West European 8-bit character set
>
> Pierre Carrier <pierre.carrier_at_sympatico.ca> wrote in message
> news:3836EC25.4ECB9995_at_sympatico.ca...
> > Does anyone has done a load from a MainFrame binary file (EBCDIC char
> > set) into Oracle 8 for UNIX (AIX)?
> >
> > Since we have large file to transfer and load, we are looking to do
> > the FTP transfer in a binary mode instead of ASCII mode to reduce the
> > time to transfer the data across the network. But to acheive that we
> > would require Oracle to be able to read and load that binary file coming
> > from the MainFrame. Going through the documentation of Oracle I didn't
> > find anything on this. So if anyone knows how and would be willing to
> > share this information, it would be very helpfull.
> >
> > Thanks in advance.
> >
Received on Sat Nov 27 1999 - 16:47:42 CST