Sql

NVARCHAR and NCHAR in oracle Oracle supports multiple charactersets at the same time through its use of the NLS* paramters. select * from nls_database_parameters where parameter in ('NLS_LENGTH_SEMANTICS', 'NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET'); There are two things to note The value of NLS_CHARACTERSET The value of NLS_NCHAR_CHARACTERSET on my system the values are the following NLS_NCHAR_CHARACTERSET = AL16UTF16 NLS_CHARACTERSET = WE8ISO8859P1 If you haven’t already guessed from the title of this article, NVARCHAR and NCHAR are two additional data types which behave similar to VARCHAR and CHAR....