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

Andrea MMar 19 2008 — edited Mar 19 2008

Hi all,

I was wondering what are the main advantages in using CLOB instead of BLOB for storing long texts in rtf format?
Could I have problems in migrating such data to a different database (with imp / exp or impdp / expdp)?
Could I lose some "special characters" if the client NLS_LANG setting are different from the server's ones?

thanks for every suggestion!

andrea

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2008

Added on Mar 19 2008

#general-database-discussions

1 comment

10,645 views