Link to home
Create AccountLog in
Oracle Database

Oracle Database

--

Questions

--

Followers

Top Experts

Avatar of 123456
123456🇮🇷

Managing Character Set
Hi Experts,
I read this Paragraph  From Micheal ault book( Administrating and Administration oracle 9i)
"You must Verify That the Registry on NT is Set with the same character set as the database,
or data Problems and performance degradation will occur. this applies to all client,workstation,
including windows 95,98,NT, as well as windows 2000-based units".
How Can I manage this work?
I want to Configure My oracle Db for Arabic Character.

My oracle version: oracle 9i
os:win2k advanced Server.


Thanks in advance For your Comments
Hamid Reza

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of schwertnerschwertner🇦🇶

You have to create your Oracle instance setting as character set AL32UTF8.
Then simply set in the registry (ORACLE)
NLS_LANG ---> .UTF8

Avatar of 123456123456🇮🇷

ASKER

I Migrated From oracle 8i to 9i
and my scripts on last oracle 8i is
based AR8MS1256.
Does your proposed character set Work with
My previous character set too?

Avatar of 123456123456🇮🇷

ASKER

>You have to create your Oracle instance setting as character set AL32UTF8.
Then simply set in the registry (ORACLE)
NLS_LANG ---> .UTF8<

i did it but raised this error For me:
ORA-01756-

how can i solve this problem?

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of 123456123456🇮🇷

ASKER

My problem was solved with only changes in Registry with changing
NLS_LANG = MERICAN_AMERICA.AR8MSWIN1256



ASKER CERTIFIED SOLUTION
Avatar of NetminderNetminder

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Oracle Database

Oracle Database

--

Questions

--

Followers

Top Experts

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.