Community resource center

Description

One of the common errors that occurs during the WorkflowGen installation for Oracle is due to unsupported character set settings of the database instance. WorkflowGen is a multi-lingual software application which requires storage in UTF-8 encoding.

Solution

The database must use CHARACTER SET and NATIONAL CHARACTER SET in UTF8. If the character sets could not be changed then a new database instance is required. Use the following query to verify the character sets in the Oracle SQL Command Line tool.

- SELECT * FROM nls_database_parameters WHERE parameter like ’%CHARACTERSET’;

Reference

WorkflowGen Technical Guide - Chapter 3.1.2 Installation on Oracle 9i / 10g database.

http://community.workflowgen.com/downloads/documentation/WorkflowGen-Technical-en.pdf