What is the difference between varchar and varchar2 ?

Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Next Question:
How could we differentiate between codes and standards. How these both can be us...
Posted by:
Mohammed Abdul Jaleel Mohammed
22-April-2017

VARCHAR is reserved by Oracle to support distinction between NULL and empty string in future, as ANSI standard prescribes. VARCHAR2 does not distinguish between a NULL and empty string, and never will. If you rely on empty string and NULL being the same thing, you should use VARCHAR2.

SQL Database

Question ajoutée par Akwin Dhas
Date de publication: 2017/09/29

Apprécier (0) Vues (4) Suiveurs (1) Réponses (1) Report Question

Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.

1 Réponses

par Akwin Dhas

VARCHAR is reserved by Oracle to support distinction between NULL and empty string in future, as ANSI standard prescribes.
VARCHAR2 does not distinguish between a NULL and empty string, and never will.
If you rely on empty string and NULL being the same thing, you should use VARCHAR2.

Apprécier (0)

Déprécier Réponses () Rapport