NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET

[fordikon]

1. What is the diff between NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET
in oracle 9i database.



2. Is it possible to change the characterset after it is assigned to the database initially?.

Thanks in advance

[akhadar]

1.CHECK THIS LINK
http://asktom.oracle.com/pls/ask/f?p...6611635063661,

2.u can change the database character set by using ALter database command but there is no gaurantee about your data consistency that is reason why oracle recommends which character set u want to use while u design your database.