Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to show default char encoding and how to switch from UTF-8 to e.g.ANSI?

pstein-JavaNetSep 21 2011 — edited Sep 28 2011

As far as I know during installation of Oracle the user has to tell Oracle what type of encoding should be the default encoding for (VAR)CHARs e.g.

UTF-8
ANSI
UTF-16
....

Is this a setting per database, per TABLE or per installation?

How can I find out the current setting of an Oracle (database/table/installation) ?

How can I switch this default setting AFTER installation e.g. from UTF-8 to ANSI ?

Peter

This post has been answered by Pierre Forstmann on Sep 28 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 26 2011

Added on Sep 21 2011

#general-database-discussions

6 comments

2,122 views