EBCDIC

From Oracle FAQ
Jump to: navigation, search

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.

[edit] 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;

[edit] Loading

The SQL*Loader FAQ shows how EBCDIC data can be loaded into an Oracle database.

[edit] 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 #