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

Report message to a moderator

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: 68665
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 11:12:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.