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!

SQL Server 2k Data Type Mapping: RAW vs BLOB

534888Sep 26 2006 — edited Sep 26 2006

Is Oracle RAW being phased out? Is BLOB the preferred substitution?

I need to convert ‘Binary(8)’ and ‘varbnary(1000)’ from SQL Server 2k to Oracle 10g R2 (using OMWB). Should I convert them to ‘RAW(8)’ and ‘RAW(1000)’? or convert both to ‘BLOB’?

What is the difference between ‘RAW’ and ‘BLOB’? Is there a significant different in performance (RAW vs BLOB) when the data is less than 2000 bytes?

Thanks in advance,
Helen

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2006

Added on Sep 26 2006

#database-and-application-migrations

2 comments

1,357 views