Idea Details

Installer should warn that oracle characterset needs to be AL32UTF8

Last activity 06-25-2019 12:40 PM
james.kimber's profile image
10-06-2015 04:51 AM

I am currently working on project to change the character set of Citi's CMS from WE8S08859P1 to AL32UTF8 simple because someone failed to read the documentation and create the oracle database with the correct character set.



The effects of this are:


a) Non-ascii characters on the subject line appear as question marks

b) iConsole text highlighting doesn't work for non-ascii characters


It's a huge effort to fix this involving a complete database export / import and considerable amounts of testing.

All because:

a) The installer doesn't check this during install

b) The information is buried in 1000's lines of documentation.


To check the database character set, execute the query:



SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;


If the database has been setup correctly, this should return AL32TUF8



Note: this is only applicable to Oracle


06-25-2019 12:40 PM

For your reference, CA Data Protection has been announced as End of Life,  (please refer to the link below) and as such there will be no further enhancements added to the product.

CA Data Protection Stabilization and End of Life Announcement 

Data Protection Product team

01-26-2016 09:49 PM

This idea still shows as NEW over 3 months after submission!