Geek Answers Handbook

Oracle data type for text file?

I need to create a table in Oracle that will store a series of large text files. Looking at the Oracle data type, it is not clear which type I should use to store files.

Restrictions on specific texts like VARCHAR2 seem very small (32K). Other types do not seem to match the correct text file match (e.g. BFILE).

Does anyone have an opinion on the right type?

+5
source share
3 answers

The difference between CLOB and BLOB / BFILE is that CLOBs are treated as Text. That is, if you pull the CLOB from the database, it will do any conversion necessary from the database character set to the client character set (for example, removing the accent from ê). Similarly, when a CLOB is created by the client, there may be a conversion from the client character set to the database character set. If both client and database character sets are the same, then no conversion is required or is performed.

NCLOB is similar to CLOB, except that instead of using the database character set, the conversion uses the NLS NCHAR character set.

BLOB / BFILE will not obey conversion rules.

, GENERALY CLOB , /, , BLOB/BFILE. RAW.

+9

, Oracle . CLOB Long

+1

LOB - CLOB NCLOB. 8 (CLOB) (NCLOB).

Oracle LONG RAW LOB. LOB , LONG. , LOB , LONG RAW .

+1

More articles:


All Articles