Updated on 2024-11-07 GMT+08:00

Checking Character Sets

The system checks character sets of the source and target databases. This check result does not affect subsequent operations. Table 1 and Table 3 describe the character set compatibility.

Character set compatibility result:

  • Alarm: The character sets of the source and target databases are incompatible.
  • Success: The character sets of the source and target databases are compatible.
Table 1 Character set compatibility between Oracle and GaussDB

Source Database

Target Database

Result

SQL_ASCII

SQL_ASCII

Success

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Alarm

UTF8

Alarm

UTF32

Alarm

Other character sets

Alarm

US7ASCII

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Alarm

UTF8

Alarm

UTF32

Alarm

Other character sets

Alarm

ISO-8859-1

SQL_ASCII

Alarm

ISO-8859-1

Success

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Alarm

UTF8

Alarm

UTF32

Alarm

Other character sets

Alarm

LATIN1

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Success

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Alarm

UTF8

Alarm

UTF32

Alarm

Other character sets

Alarm

GB2312

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Success

GBK

Success

GB18030

Success

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

ZHS16GBK

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Success

GB18030

Success

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

GBK

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Success

GB18030

Success

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

ZHS32GB18030

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Success

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

GB18030

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Success

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

AL16UTF16

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

UTF16

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

AL32UTF8

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

UTF8

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

UTF32

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

Other character sets

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Alarm

UTF8

Alarm

UTF32

Alarm

Other character sets

Alarm

Table 2 Character set compatibility between MySQL and GaussDB

Source Database

Target Database

Result

ISO-8859-1/LATIN1

SQL_ASCII

Alarm

ISO-8859-1

Success

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Alarm

UTF8

Alarm

UTF32

Alarm

Other character sets

Alarm

GB2312

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Success

GBK

Success

GB18030

Success

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

GBK

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Success

GB18030

Success

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

GB18030

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Success

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

UTF16

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

UTF8

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

UTF32

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

ASCII

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Alarm

UTF8

Alarm

UTF32

Alarm

Other character sets

Alarm

UTF8MB3

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Success

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

UTF8MB4

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

UTF16LE

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Success

UTF8

Success

UTF32

Success

Other character sets

Alarm

Other character sets

SQL_ASCII

Alarm

ISO-8859-1

Alarm

LATIN1

Alarm

GB2312

Alarm

GBK

Alarm

GB18030

Alarm

UTF16

Alarm

UTF8

Alarm

UTF32

Alarm

Other character sets

Alarm

Table 3 Character set compatibility between Oracle and MySQL

Source Database

Target Database

Result

SQL_ASCII

ASCII

Success

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Alarm

UTF16LE

Alarm

UTF8

Alarm

UTF32

Alarm

UTF8MB4

Alarm

Other character sets

Alarm

US7ASCII

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Alarm

UTF16LE

Alarm

UTF8

Alarm

UTF32

Alarm

UTF8MB4

Alarm

Other character sets

Alarm

ISO-8859-1

ASCII

Alarm

LATIN1/ISO-8859-1

Success

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Alarm

UTF16LE

Alarm

UTF8

Alarm

UTF32

Alarm

UTF8MB4

Alarm

Other character sets

Alarm

LATIN1

ASCII

Alarm

LATIN1/ISO-8859-1

Success

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Alarm

UTF16LE

Alarm

UTF8

Alarm

UTF32

Alarm

UTF8MB4

Alarm

Other character sets

Alarm

GB2312

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Success

GBK

Success

UTF8MB3

Success

GB18030

Success

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

ZHS16GBK

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Success

UTF8MB3

Success

GB18030

Success

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

GBK

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Success

UTF8MB3

Success

GB18030

Success

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

ZHS32GB18030

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Success

UTF8MB3

Success

GB18030

Success

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

GB18030

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Success

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

AL16UTF16

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

UTF16

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

AL32UTF8

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

UTF8

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

UTF32

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Success

UTF16LE

Success

UTF8

Success

UTF32

Success

UTF8MB4

Success

Other character sets

Alarm

Other character sets

ASCII

Alarm

LATIN1/ISO-8859-1

Alarm

GB2312

Alarm

GBK

Alarm

UTF8MB3

Alarm

GB18030

Alarm

UTF16

Alarm

UTF16LE

Alarm

UTF8

Alarm

UTF32

Alarm

UTF8MB4

Alarm