Database Software

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!

AL32UTF8 / US7ASCII db characterset

user88831Apr 12 2012 — edited Apr 16 2012

Hi Guys,

My DB is currently on 10.2.0.5 using US7ASCII as character set. Definately for now and future, my DB will only be storing english language.

We are intending to migrate to 11g database. Have some queries to ask experts out there (pardon me, i have not started testing. very soon i will)
1. when creating db in 11g, can we choose the character set as us7ascii?
2. oracle recommended to use unicode in 11g (eg: al32utf8). For my case here, does it bring any benefits to me by changing us7ascii to al32utf8 since i'm quite sure we will only be using english? Not sure if it's work the risk or efforts to migrate as my application is very huge.
3. if the db is converted from us7ascii to al32utf8 successfully (without any loose of data using csscan), do i have to change anything on the application end? Will it impact the application in anyway if the db character set is changed?

thanks

This post has been answered by JustinCave on Apr 16 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 14 2012

Added on Apr 12 2012

#database-key-features, #globalization-support

10 comments

8,220 views