The required codepage for oracle

[Former Member]

Could anybody please tell what is the required codepage for oracle?

Our system has NLS_LANG=AMERICAN_AMERICA.WE8DEC. Version is NW701.

Thanks a lot!

[Former Member · Accepted solution]

Hi,

Since you're already on NW 701, if you are not already Unicode (which it seems is the case since your NLS_LANG variable is still WE8DEC), you may want to consider Unicode.

The NLS_LANG for Unicode is NLS_LANG=AMERICAN_AMERICA.UTF8 (both my Unix and Windows Unicode environments have this variable set).

Additonally, make sure your OS has the correct locales you'll need. You can use program RSCPINST to test this (only if you're not already Unicode'ed).

[Former Member · Accepted solution]

Thanks!

We do not want to convert to unicode at this time.

Would you please tell what is the required codepage for Oracle so that I can complete current export?

Regards.

[Former Member · Accepted solution]

Z,

Your character set should be WE8DEC then (since your are not Unicoded and I am assuming you are only storing English Language)...

You can run this SQL to verify settings on your DB:

SELECT * from NLS_DATABASE_PARAMETERS;

[Former Member · Accepted solution]

I verified , it is not a unicode system.

So what is the required codepage fro Oracle?

Thanks!