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:
- GBK
- GBK-FULLWIDTH
- IBM037
- IBM273
- IBM277
- IBM278
- IBM280
- IBM284
- IBM285
- IBM297
- IBM500
- IBM833
Since v6.1.0/31 - IBM836
- IBM838
Since v6.1.0/31 - IBM870
Since v6.1.0/31 - IBM871
- IBM875
- IBM930
Since v6.2.0/18,Since v6.2.5/8 - IBM933
Since v6.1.0/59,Since v6.1.5/8 - IBM937
Since v6.1.0/36 - IBM939
Since v6.1.0/32 - IBM943
As CHAR FOR BIT DATA or BINARY types only * - IBM1025
Since v6.1.0/31 - IBM1026
Since v6.1.0/31 - IBM1047
- IBM1123
Since v6.1.0/31 - IBM1156
Since v6.1.0/59,Since v6.1.5/9 - IBM1157
Since v6.1.0/59,Since v6.1.5/9 - IBM1364
Since v6.1.0/59,Since v6.1.5/8 - IBM1388
Since v6.1.0/32 - IBM00924
- IBM01140
- IBM01141
- IBM01142
- IBM01143
- IBM01144
- IBM01145
- IBM01146
- IBM01147
- IBM01148
- IBM01149
- IBM28709
Since v6.1.0/36 - IBM-935-DB2I
- US-ASCII
- UTF-8
- UTF-16BE / UTF-16LE
- WINDOWS-1251
- WINDOWS-1252
* For Db2 for i some character encodings are supported as a binary data (HEX codes of symbols) stored in CHAR FOR BIT DATA or BINARY column types only. To capture such columns the HVR_DB_CHARSET_BITDATA or HVR_DB_CHARSET_BITDATA (respectively) environment variable should be set in a channel to instruct HVR to treat CCSID 65535 data as character data with the specified encoding.
Db2 for Linux, Unix and Windows
HVR supports the following character encodings for Db2 for Linux, Unix and Windows:
- GBK
- IBM943
Since v6.2.0/21,Since v6.2.5/9 - ISO-8859-1
- ISO-8859-2
- ISO-8859-5
- ISO-8859-6
Since v6.2.0/21,Since v6.2.5/9 - ISO-8859-9
- ISO-8859-15
- UTF-8
- WINDOWS-874 ("TIS620-1")
Since v6.2.0/21,Since v6.2.5/9 - WINDOWS-950 ("Big5")
Since v6.2.0/21,Since v6.2.5/9 - WINDOWS-1250
Since v6.2.0/21,Since v6.2.5/9 - WINDOWS-1251
- WINDOWS-1252
- WINDOWS-1253
Since v6.2.0/21,Since v6.2.5/9 - WINDOWS-1254
Since v6.2.0/21,Since v6.2.5/9 - WINDOWS-1255
Since v6.2.0/21,Since v6.2.5/9 - WINDOWS-1256
Since v6.2.0/21,Since v6.2.5/9 - WINDOWS-1257
Since v6.2.0/21,Since v6.2.5/9 - WINDOWS-1258
Since v6.2.0/21,Since v6.2.5/9
Db2 for z/OS
HVR supports the following character encodings for Db2 for z/OS:
- GBK
- GBK-FULLWIDTH
- IBM037
- IBM273
- IBM277
- IBM278
- IBM280
- IBM284
- IBM285
- IBM297
- IBM500
- IBM833
Since v6.1.0/31 - IBM836
- IBM838
Since v6.1.0/31 - IBM870
Since v6.1.0/31 - IBM871
- IBM875
- IBM930
Since v6.2.0/18,Since v6.2.5/8 - IBM933
Since v6.1.0/59,Since v6.1.5/8 - IBM937
Since v6.1.0/36 - IBM939
Since v6.1.0/32 - IBM943
Since v6.1.0/32 - IBM1025
Since v6.1.0/31 - IBM1026
Since v6.1.0/31 - IBM1047
- IBM1123
Since v6.1.0/31 - IBM1156
Since v6.1.0/59,Since v6.1.5/9 - IBM1157
Since v6.1.0/59,Since v6.1.5/9 - IBM1364
Since v6.1.0/59,Since v6.1.5/8 - IBM1388
Since v6.1.0/32 - IBM00924
- IBM01140
- IBM01141
- IBM01142
- IBM01143
- IBM01144
- IBM01145
- IBM01146
- IBM01147
- IBM01148
- IBM01149
- IBM01162
Since v6.1.0/32 - IBM28709
Since v6.1.0/36 - IBM-935
- US-ASCII
- UTF-8
- UTF-16BE
- WINDOWS-1251
- WINDOWS-1252
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-9
Since v6.1.0/75,Since v6.2.0/13,Since v6.2.5/5 - 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:
- IBM437
- IBM850
- UTF-8
Since v6.1.0/83,Since v6.2.0/21,Since v6.2.5/9 - UTF-16LE
- 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
- WINDOWS-1258
Sybase ASE
HVR supports the following character encodings for Sybase ASE:
- IBM437
- IBM850
- GBK
- ISO-8859-1
- ISO-8859-5
- ISO-8859-15
- UTF-8
- UTF-16BE / UTF-16LE
- 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
- WINDOWS-1258
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