gpt4 book ai didi

database - Oracle:LONG 还是 CLOB?

转载 作者:太空狗 更新时间:2023-10-30 01:44:57 35 4
gpt4 key购买 nike

从这两个线程,

LONG 已过时且已弃用。 Oracle says ,

Do not create tables with LONG columns. Use LOB columns (CLOB, NCLOB) instead. LONG columns are supported only for backward compatibility.

Oracle also recommends that you convert existing LONG columns to LOB columns. LOB columns are subject to far fewer restrictions than LONG columns. Further, LOB functionality is enhanced in every release, whereas LONG functionality has been static for several releases.

但是如果没有 the workarounds mentioned here,您将无法从远程数据库中读取 CLOB .

我应该选择哪一个来在我的表格中存储一些文本?或者有比这两个更好的解决方案吗?

最佳答案

使用 CLOB。 LONG 的局限性之一是无法从 SQL - PL/SQL 正确处理 LONG。

有关差异的更详细说明,请参阅 http://www.comp.dit.ie/btierney/oracle11gdoc/appdev.111/b28393/adlob_tables.htm#insertedID2

关于database - Oracle:LONG 还是 CLOB?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/3599211/

35 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com