EBCDIC
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
EBCDIC (Extended Binary-Coded Decimal Interchange Code) is a standard character-to-number encoding (similar to ASCII) used by some IBM computer systems. For example, Oracle on OS/390 (IBM MVS) stores data as EBCDIC characters.
Convert to/from
The CONVERT() function can be used to translate between EBCDIC and other character sets. Example:
SELECT CONVERT('aBcDeF09', 'WE8EBCDIC500', 'US7ASCII') FROM dual;
Loading
The SQL*Loader FAQ shows how EBCDIC data can be loaded into an Oracle database.
Also see
- ASCII, alternative character encoding
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
