While
setting up an Oracle database to host your VMware vCloud Director information
you may stumble at the Character Set definition for your database.
Character
Set may be interpreted as how the system computes and stores the information,
they use numeric codes instead of the graphical representation of the
character.
Now you
might realize how critical is for the system to convert data between character
set correctly, especially in a multi language environment.
If you want
to learn mor about Oracle Character Set check the Oracle Documentation here.
So, what
about VMware vCloud Director, what language does that use and how should we set
up the character set for it’s database ?
It’s fact,
there’s no information at VMware documentation : (
The
only thing that can helps us on these situations is the field experience.
Therefore I talked
with a few VMware’s fellows and what worked on every case was:
NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_NCHAR_CHARACTERSET AL16UTF16
So, use this
configuration and you will be fine.
The only documented
thing on vCloud Director 5.1.1 Release Notes is that you should not use
NLS_CHARACTERSET JA16SJISTILDE. This
know issue was not documented on vCloud Director 5.1.2 Release Notes anymore but
neither did I see it on the Resolved Issues section, so If I were you I would stay
away of this configuration for now.
See you next..
