Oracle Database Discussions

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!

clob vs blob

325411May 22 2003 — edited May 22 2003

1. Could you please tell me the advantages of CLOB over BLOB( i have searched in most of the sites but there is no clear definition except --> CLOB is used to store character data and BLOB is used to store Binary data. Could you please elaborate it)

2. Suppose i have a text file(EDI format) if i store it in CLOB how much space it will take and will it take the same space if stored in BLOB.

3. Will there be any performance improvement in Storing/retreiving a text file in CLOB instead of storing it in a BLOB.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2003

Added on May 22 2003

#general-database-discussions

1 comment

604 views