COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: adityaupadhyay on 09 Jul 2012 02:28:45 AM

Title: Changing character set in oracle for cognos installation
Post by: adityaupadhyay on 09 Jul 2012 02:28:45 AM
Hi,

I am trying to install Cognos  8.4 with oracle 10g express edition. When I am trying to test the content store , following error is comng:

[ ERROR ] Content Manager cannot start because the database character set for the content store is not supported. Before you restart Content Manager, you may need to recreate the content store database or clean it using dbClean_*.sql.

I am trying to change the character set. But oracle is not allowing me to do that. Following error is coming:

error ORA-12712: new character set must be a superset of old character set

Please help me in completing the installation. The default character set in oracle 10g express edition is

Title: Re: Changing character set in oracle for cognos installation
Post by: MFGF on 09 Jul 2012 10:01:27 AM
Sounds like you will need to drop the original content store database and create a new one using a supported character set.

Regards,

MF.
Title: Re: Changing character set in oracle for cognos installation
Post by: chunduri on 12 Oct 2012 06:35:54 AM
the default character set in oracle is ALTF-32 or 16 but cognos only supports unicode(UTF-8).

so u need to change the character set to UTF-8