Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)

by

The NVARCHAR2 datatype was introduced by Oracle for databases that want to use Unicode for some columns while keeping another character set for the rest of the database (which uses VARCHAR2). The NVARCHAR2 is a Unicode-only datatype.

One reason you may want to use NVARCHAR2 might be that your DB uses a non-Unicode character set and you still want to be able to store Unicode data for some columns without changing the primary character set. Another reason might be that you want to use two Unicode character set (AL32UTF8 for data that comes mostly from western Europe, AL16UTF16 for data that comes mostly from Asia for example) because different character sets won’t store the same data equally efficiently.

Both columns in your example (Unicode VARCHAR2(10 CHAR) and NVARCHAR2(10)) would be able to store the same data, however the byte storage will be different. Some strings may be stored more efficiently in one or the other.

Note also that some features won’t work with NVARCHAR2, see this SO question:

More Related Contents:

  1. URL string format for connecting to Oracle database with JDBC
  2. How to uninstall / completely remove Oracle 11g (client)?
  3. How can I set a custom date time format in Oracle SQL Developer?
  4. Get counts of all tables in a schema
  5. Determining location of relevant tnsnames.ora file
  6. Default row ordering for select query in oracle
  7. oracle convert unix epoch time to date
  8. Oracle trigger after insert or delete
  9. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  10. Difference between a user and a schema in Oracle?
  11. Base64 encoding and decoding in oracle
  12. What is the dual table in Oracle?
  13. How to avoid variable substitution in Oracle SQL Developer
  14. Recursion In Oracle
  15. creating parameterized views in oracle11g
  16. Oracle’s default date format is YYYY-MM-DD, WHY?
  17. PL/SQL print out ref cursor returned by a stored procedure
  18. How to use a table type in a SELECT FROM statement?
  19. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  20. Trigger to enforce M-M relationship
  21. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  22. Oracle: how to INSERT if a row doesn’t exist
  23. Valid Date Checks in Oracle
  24. Functions vs procedures in Oracle
  25. Oracle: difference between max(id)+1 and sequence.nextval
  26. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  27. Why cannot I create triggers on objects owned by SYS?
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. How to View Oracle Stored Procedure using SQLPlus?

Leave a Comment