I have a 9i database in WE8ISO8859P1
A new requirement came in to store some data like book titles in Russian, arabic, and other foreign languages.
What would be the best thing to do?
a) change the whole database to UTF-8. that would to create a new DB and migrate data and test everything - lot of work i expect
b) create new columns with NVARCHAR2(4000) or NCLOB type. This would require many code changes in the client code.
c) Change exisitng columns that need to store foreign data from VARCHAR2 to NVARCHAR2.
Would c) work. Is not this the best and easiest solution. would there be any consequences in data stored in DB or pl/sql web client (SQL) or power builder client accessing the data.