SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Choice between clob vs blob column

20197Jan 28 2009 — edited Jan 28 2009

I need to store text (eg. *.txt, *.html, *.xml etc) and binary (eg. *.zip, *.doc, *.pdf etc) files in the database. I have two choices:
1) Single blob column.
2) Separate clob and blob columns.

What I have found is that when uploading a text file into a clob column using dbms_lob.loadFromFile, I get garbage. However if I use dbms_lob.loadClobFromFile, the character conversion is handled correctly. I have not tried this, but I guess that if used dbms_lob.loadFromFile to upload a text file into a blob column, I would not have any problems.

What I would like to know if there are other issues I should be aware of with the two choices.

Thanks

Sanjeev

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 25 2009

Added on Jan 28 2009

5 comments

4,086 views