Skip to Content

Character encoding in Jitterbit Harmony

Introduction

The default character encoding for the Harmony platform is UTF-8 as of agent version 12.7 and Design Studio version 11.63. In earlier versions, the default encoding is Latin-1 (ISO-8859-1).

Cloud and private agents use ICU Unicode and globalization code page table libraries. Supported character encodings and aliases for cloud and private agents are cataloged on the ICU converter website.

Override the default character encoding

To use a character encoding other than the default, you can set it explicitly. Some connectors (for example, File Share, FTP, Local Storage, and Temporary Storage) include a configuration option for setting the character encoding.

Alternatively, you can use any of the following Jitterbit variables in a script to set the character encoding:

  • jitterbit.source.db.character_encoding

  • jitterbit.target.db.character_encoding

  • jitterbit.source.text.character_encoding

  • jitterbit.target.text.character_encoding

  • jitterbit.scripting.db.character_encoding

The value should be the code page converter name or alias, as shown in the following example:

$jitterbit.scripting.db.character_encoding="ebcdic-xml-us"