EnterpriseOne 8.9 upgrade and Unicode

All,

We will be performing the upgrade from XE to 8.9 soon and I am wondering how others have handled the unicode requirements. Can I change the current db instance to unicode and then add tablespaces, or do I have to create a new unicode db instance???

Any thoughts??

maybe if you tell us what your database and platform is . . .?

Sorry....

Oracle 9i / Solaris 8

As the character set configuration is instance specific, not tablespace
specific, you will need to setup a new instance. Unless your character
set is already configured to handle this?

NLS_CHARACTERSET needs to be WE8MSWIN1252. NLS_NCHAR_CHARACTERSET needs
to be AL16UTF16.

Brent Marxhausen
DBT, Inc.
Independent CNC Consultant
EMail: [email protected]

Re: RE: EnterpriseOne 8.9 upgrade and Unicode

Brent,
I read through the Unix Ugrade Guide and understood something different. Whether a register is unicode or not is not per instance, but per table column.
NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are two different chrsets, they are used depending on the column type. (As far as I know it works this way on AS400/DB2 as well.)
If it was as you say, one would need two Oracle instances to upgrade, all new datasources would be in one, Business Data and Control Tables in the other. This is because these two remain non-unicode until the upgrade is comlete.

I am not an Oracle guru nor unicode specialist. Please tell me if I am wrong. I need to understand this at some point.

Thanks, Gerd

Actually, in Oracle these two character sets 'coexist' in a single
instance. During the Oracle installation it asks for two values.

The way I think of it is answering two questions, 'What is your general
character set?', but in the event that a table definition calls for a
Unicode data type, like NCHAR, 'What is your Unicode character set?'

Brent Marxhausen
DBT, Inc.
Independent CNC Consultant
EMail: [email protected]