Oracle：LONG还是CLOB？ [英] Oracle: LONG or CLOB?
问题描述
从这两个主题中，
- Why is LONG an issue with Oracle?
- Is it possible to read a CLOB from a remote Oracle database?
LONG是古老的，已弃用。 Oracle说，
LONG is archaic and deprecated. Oracle says,
不要创建具有LONG列的表。请改用LOB列（CLOB，NCLOB）。只有向后兼容才支持LONG列。
Do not create tables with LONG columns. Use LOB columns (CLOB, NCLOB) instead. LONG columns are supported only for backward compatibility.
Oracle还建议将现有LONG列转换为LOB列。 LOB列受限于比LONG列少得多的限制。此外，LOB功能在每个版本中都得到了增强，而LONG功能在几个版本中已经是静态的。
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.
但是你不能读取CLOB没有的远程数据库这里提到的解决方法。
But you cannot read a CLOB from a remote database without the workarounds mentioned here.
我应该选择哪一个在我的表格中存储一些文本？比这两个？
推荐答案
使用CLOB。 LONG的一个限制是不能从SQL - PL / SQL正确处理LONG。
Use CLOBs. One limitation of LONG is that LONGs can't be handled correctly from SQL - PL/SQL.
有关差异的更详细说明，请参阅 http://www.comp.dit.ie/btierney/oracle11gdoc/appdev.111/b28393/adlob_tables.htm#insertedID2
For a more detailed description of the differences, see http://www.comp.dit.ie/btierney/oracle11gdoc/appdev.111/b28393/adlob_tables.htm#insertedID2
这篇关于Oracle：LONG还是CLOB？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
