I am planning to migrate to 126.96.36.199.0 . My present DB version is 188.8.131.52.0 64bit on solaris 5.10 and my present character set is US7ASCII.
I want to keep the provision for non-english data too, though currently my DB is storing only English language.
oracle recommended to use unicode in 11g AL32UTF8.Does it support smart characters. what are the pros/cons. Any suggestions for other character set...kindly suggest.
Depends on what you mean by "smart character" - the documentation lists the capabilities of the various charactersets
It is recommended that you use AL32UTF8 - one simple way would be for you to upgrade using export/import. How big is your database ? How much downtime can you afford ?