Supported Character Encodings

Fivetran HVR supports a large number of character encodings for each DBMSs.

Db2 for i

HVR supports the following character encodings for Db2 for i:

Db2 for Linux, Unix and Windows

HVR supports the following character encodings for Db2 for Linux, Unix and Windows:

Db2 for z/OS

HVR supports the following character encodings for Db2 for z/OS:

Google BigQuery

HVR supports the following character encoding for Google BigQuery:

• UTF-8-NONUL (zero byte 0x00 is not supported in this encoding)

Greenplum

HVR supports the following character encodings for Greenplum:

• ISO-8859-1
• UTF-8-NONUL (zero byte 0x00 is not supported in this encoding)
• WINDOWS-1252

Ingres

HVR supports the following character encodings for Ingres:

• ISO-8859-1
• ISO-8859-15 Since v6.1.0/12
• UTF-8
• UTF-16BE / UTF-16LE
• WINDOWS-1252

There is a known issue in Ingres when using prepared statements to insert data with UTF-8 encoding into columns with the LONG VARCHAR data type. This can sometimes cause the data to be corrupted.
For further assistance on addressing this issue (Ingres issue number II-11621), refer to Ingres documentation or contact Actian Ingres support.

MySQL

HVR supports the following character encodings for MySQL:

• GBK
• UCS-2BE
• US-ASCII
• UTF-8
• UTF-8-BMP
• UTF-16BE
• WINDOWS-1251
• WINDOWS-1252

Oracle

HVR supports the following character encodings for Oracle:

• CESU-8
• CL8ISO8859P5MN
• GBK
• ISO-8859-1
• ISO-8859-5
• ISO 8859-6 Since v6.1.5/7, Since v6.1.0/53
• ISO-8859-15
• JA16SJIS Since v6.1.5/7, Since v6.1.0/54
• TH8TISASCII Since v6.1.0/32
• US-ASCII
• UTF-8
• UTF-16BE / UTF-16LE
• WINDOWS-949
• WINDOWS-1252

PostgreSQL

HVR supports the following character encodings for PostgreSQL:

• UTF8 (zero byte 0x00 is not supported in this encoding)
• ISO_8859_5
• ISO_8859_6 Since v6.1.5/8
• LATIN1 (ISO88591)
• LATIN5 Since v6.1.5/8
• LATIN9 Since v6.1.5/8
• WIN1250 Since v6.1.5/8
• WIN1251
• WIN1252
• WIN1253 Since v6.1.5/8
• WIN1254 Since v6.1.5/8
• WIN1255 Since v6.1.5/8
• WIN1256 Since v6.1.5/8
• WIN1257 Since v6.1.5/8
• WIN1258 Since v6.1.5/8

Special characters in table and column names are not supported for PostgreSQL.

Redshift

HVR supports the following character encoding for Redshift:

• UTF-8-BMP-NONUL (zero byte 0x00 is not supported in this encoding)

SAP HANA

HVR supports the following character encoding for SAP HANA:

• CESU-8-REG

SingleStore

HVR supports the following character encoding for SingleStore:

• UTF-8-BMP

Snowflake

HVR supports the following character encoding for Snowflake:

• UTF-8

SQL Server

HVR supports the following character encodings for SQL Server:

Sybase ASE

HVR supports the following character encodings for Sybase ASE:

Teradata

HVR supports the following character encodings for Teradata:

• ISO-8859-1
• UTF-8
• UTF-16BE / UTF-16LE

There are some code points not supported by Teradata. You can find the full list here:

Unsupported Teradata Codepoints.txt