CODEPAGE 

Definition

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

Structure

CODEPAGE

CODEPAGEID	CHAR(32)	Names 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.

Explanation

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. The privilege to change the content of this table is restricted to SYSDBA.

All database users can read-access the entries in the CODEPAGE table.

See also:

Loader, SET Command

Additional System Tables

Concepts of the Database System, Users, Authentication and Authorizations