We are in process of upgrading databases from 126.96.36.199 to 9.2.0 on Solaris8. I tried to upgrade one of the database using Database upgrade assistant and I got the following warning message:
Your database is using US7ASCII as the NCHAR type.In Oracle9i, the NCHAR datatypes are limited to the Unicode character set encoding(UTF8 and AL16UTF16) only.So change NCHAR columns in user tables to one of the supported types.
Curently we are using US7ASCII both for database character set and for NCHAR and we don't have any plan to support any other language in future except English.
So I want to know that do I really have to change database character set and National Character set from US7ASCII to any other if I want to upgrade from 188.8.131.52 to 9.2.0? If yes, is there any effect on our existing applications? Do I have to make any changes?
Thanks a lot in advance.