Object documentationCODEPAGE Locate this document in the navigation structure

 

The system table SYSLOADER.CODEPAGE contains the conversion tables that the Loader uses for the conversion.

Structure

CODEPAGE

CODEPAGEID

CHAR(32)

Name of code page (for example, ISO-8859-2)

CODEPAGETABLE

CHAR(512) BYTE

Conversion table from ASCII to UCS2 for each code page

The CODEPAGE system table is preconfigured. When it is delivered, the CODEPAGE column contains 27 entries: ISO-8859-2, ISO-8859-3, ISO-8859-4, ISO-8859-5, ISO-8859-6, ISO-8859-7, ISO-8859-8, ISO-8859-9, ISO-8859-10, ISO-8859-11, ISO-8859-13, ISO-8859-14, ISO-8859-15, ISO-8859-16, WINDOWS-874, WINDOWS-932, WINDOWS-936, WINDOWS-949, WINDOWS-950, WINDOWS-1250, WINDOWS-1251, WINDOWS-1252, WINDOWS-1253, WINDOWS-1254, WINDOWS-1255, WINDOWS-1256, WINDOWS-1257. The default value of the Loader, code page ISO-8859-1, is not included in the table.

The CODEPAGE system table can only be changed by the database system administrator. If another database user tries to change the table, the Loader terminates the operation with the following error: -25251: Code page to set (<code_page_name>) not found in system table SYSLOADER.CODEPAGE. All database users can read-access the entries in the CODEPAGE table.

More Information

Loader, SET Command

Loader, Loader System Tables

Definitions of the System Tables

Database Administration, Managing Users