Home » RDBMS Server » Performance Tuning » What is the different between the varchar2 and nvarchar2?
What is the different between the varchar2 and nvarchar2? [message #270256] Wed, 26 September 2007 06:06 Go to next message
psiva_oracle
Messages: 25
Registered: August 2007
Location: india
Junior Member
Hi,

What is the different between the varchar2 and nvarchar2 in oracle 9i?

Any one can you tell me in performance tuning persfective?


Thanks in advance.

Regards,
Siva.P
Bangalore
India
Re: What is the different between the varchar2 and nvarchar2? [message #270265 is a reply to message #270256] Wed, 26 September 2007 06:21 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Datatypes
Don't use N% datatype unless you can't do otherwise.
They are there for backward compatibility.
They were created when Unicode character sets did not exist.

Regards
Michel
Previous Topic: Library Cache Lock
Next Topic: Performance Tuning in SQL queries and PL/SQL
Goto Forum:
  


Current Time: Sun Dec 04 06:32:19 CST 2016

Total time taken to generate the page: 0.04471 seconds