Oracle中的varchar和varchar2有什么区别? [英] What is the difference between varchar and varchar2 in Oracle?

问题描述

varchar和varchar2有什么区别?

What is the difference between varchar and varchar2?

推荐答案

到目前为止，它们是同义词.

As for now, they are synonyms.

VARCHAR由Oracle保留，以便将来按照ANSI标准的规定支持NULL和空字符串之间的区别.

VARCHAR is reserved by Oracle to support distinction between NULL and empty string in future, as ANSI standard prescribes.

VARCHAR2不能区分NULL和空字符串，也永远不会.

VARCHAR2 does not distinguish between a NULL and empty string, and never will.

如果您依赖空字符串并且NULL是同一件事，则应使用VARCHAR2.

If you rely on empty string and NULL being the same thing, you should use VARCHAR2.

这篇关于Oracle中的varchar和varchar2有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！