开发者

(text + images ) files in Oracle

开发者 https://www.devze.com 2023-02-20 12:25 出处：网络

I am using Oracle 10g. My Java program gets some files having huge text contents + images. I want to Store Data (having text files with Images) in oracle. What is the best way to to insert and retri

相关专题：oracle10g

I am using Oracle 10g.

My Java program gets some files having huge text contents + images. I want to Store Data (having text files with Images) in oracle. What is the best way to to insert and retrieve the data from Oracle DB.

Should i use BLOBs or CLOBS?

Should i use XML dat开发者_开发技巧a types?

Should i use Oracle Text datatype?

Please suggest the best practice. Its pretty urgent.

If the values may include binary data such as images, then BLOB is your best bet.

If the values only contain text, then CLOB should be fine.

If the values only contain XML, then either CLOB or XMLType may be used - you'll need to work out which is better for your situation - more info here: http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16659/xdb01int.htm#ADXDB0120