I'm using Oracle 9i and implementing internationalization for my application. On the oracle site, it says that Oracle 9i supports NCHAR which is an unicode datatype exclusively. But i found that VARCHAR2 also stores unicode characters perfectly.
Q: So why do we use NCHAR datatypes?
It also says that we do not need to change the Database Character Set and just make the National Character Set UTF-8 or UTF-16 and add the column NCHAR datatype to store unicode in a non-unicode database.
But i tried this :
Database Character Set: WE8MSWIN1252
National Character Set: AL16UTF16 (default)