Tuesday, July 16, 2013

Oracle Character Set for VMware vCloud Director


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

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..

No comments:

Post a Comment

Who am I

My photo
I’m an IT specialist with over 15 years of experience, working from IT infrastructure to management products, troubleshooting and project management skills from medium to large environments. Nowadays I'm working for VMware as a Consulting Architect, helping customers to embrace the Cloud Era and make them successfully on their journey. Despite the fact I'm a VMware employee these postings reflect my own opinion and do not represents VMware's position, strategies or opinions. Reach me at @dumeirell

Most Viewed Posts

Blog Archive