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.

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 #