Oracle中varchar(max)的等效项是什么?

本文介绍了Oracle中varchar(max)的等效项是什么?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

Oracle中varchar(max)的等效项是什么?

What is the equivalent of varchar(max) in Oracle?

CLOB?

推荐答案

在Oracle中，Varchars限制为4000个字符.除此之外，您必须使用LONG或CLOB.更喜欢CLOB. LONG是较旧的等价物.

Varchars are limited to 4000 characters in Oracle. Other than that, you have to use a LONG or a CLOB. Prefer CLOBs. LONGs are the older equivalent.

从此Oracle文档:

LOB与LONG和LONG RAW

LOB与旧的LONG不同 和LONG RAW数据类型有很多方式.

LOBs are different from the older LONG and LONG RAW datatypes in many ways.

• LOB的最大大小为4 GB，而LONG的最大大小为2 GB 和长RAW.
• 您可以在LOB上使用随机访问和顺序访问方法；你 只能使用顺序访问方法 在LONG和LONG RAW上.
• LOB(NCLOB除外)可以是您所对象类型的属性 定义.
• 表可以有多个LOB列，但只能有一个LONG或 长原始列.

• The maximum size of a LOB is 4 Gigabytes versus 2 Gigabytes for LONG and LONG RAW.
• You can use random as well as sequential access methods on LOBs; you can only use sequential access methods on LONG and LONG RAW.
• LOBs (except NCLOBs) can be attributes of an object type that you define.
• Tables can have multiple LOB columns, but can have only one LONG or LONG RAW column.

现有LONG和LONG的迁移 建议将LOB的原始属性 由甲骨文.甲骨文计划终止支持 和LONG RAW的未来 发布.请参阅Oracle8迁移以获取 有关迁移的更多信息.

Migration of existing LONG and LONG Raw attributes to LOBs is recommended by Oracle. Oracle plans to end support of LONG and LONG RAW in future releases. See Oracle8 Migration for more information on migration.