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: 65144
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: Buffer Cache
Next Topic: row_locking
Goto Forum:
  


Current Time: Sat Aug 19 17:38:02 CDT 2017

Total time taken to generate the page: 0.06461 seconds