BLOB versus VARCHAR

We are about to port a database from InterBase 7.5 to ORACLE 10g and have a number of InterBase BLOB fields to store text comments that could range from length zero to whatever. Most comments are probably less than 300 characters but we did it this way to make use of the BLOB type and therefore never have to worry about limits.

In ORACLE would it be best to

1. continue using the BLOB field type
2. define a VARCHAR(2000) (or similar limit)
3. other..

Any advice would be very welcome

Thanks

Steve Received on Mon May 22 2006 - 08:36:52 CDT