Note: Oracle database is no longer supported as of WorkflowGen version 7.16.0. We recommend migrating to MS SQL Server 2017 or later.
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 multilingual software application that requires storage in UTF-8 encoding.
The database must use
CHARACTER SET and
NATIONAL CHARACTER SET in
UTF-8. 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.
When the tablespace is created, you should specify the Database and National Character Set to
(Ordinary) character set
The (ordinary) character set for a database can be determined with:
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
National character set
The national character set for a database can be determined with:
select value from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET';