Oracle BLOB与VARCHAR [英] Oracle BLOB vs VARCHAR

问题描述

我需要在表的列中存储一个(大型)SQL查询，并且我认为使用BLOB字段.明确地说，我要存储查询，而不是查询结果.

I need to store a (large) SQL query in a column of a table and I thought using a BLOB field. To be clear, I want to store the query, not its result.

最好使用什么:BLOB或VARCHAR?还是别的?

What's best to use: BLOB or a VARCHAR? Or something else maybe?

推荐答案

如果您要存储不能容纳在VarChar2中的文本数据，那么我认为您应该使用CLOB.

If you're going to store text data that can't fit in a VarChar2 then I think you're supposed to use a CLOB.

从 OraFaq 引用:* CLOB(字符大对象)是一种Oracle数据类型，最多可容纳4 GB的数据. CLOB方便存储文本. *

Quote from OraFaq: *A CLOB (Character Large Object) is an Oracle data type that can hold up to 4 GB of data. CLOB's are handy for storing text. *

这篇关于Oracle BLOB与VARCHAR的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！