EBCDIC
From Oracle FAQ
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[edit]
The CONVERT() function can be used to translate between EBCDIC and other character sets. Example:
SELECT CONVERT('aBcDeF09', 'WE8EBCDIC500', 'US7ASCII') FROM dual;
Loading[edit]
The SQL*Loader FAQ shows how EBCDIC data can be loaded into an Oracle database.
Also see[edit]
- 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 | # |