| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Loading EBCDIC binary file into a UNIX environment
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
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 20 1999 - 16:09:52 CST
 |
 |