Acess Memo Fields to Oracle 8 Conversion

From: <ddlang_at_my-deja.com>
Date: Thu, 01 Jul 1999 18:31:00 GMT
Message-ID: <7lgc54$l7g$1@nnrp1.deja.com>

We are upsizing an Access 95 database to Oracle 8.

Some of the fields are memo fields, and we would like to find a data type in Oracle that is as closely matched to the memo field in Access as possible. Two specific criteria are:

We don't want to have to specify the exact size, so we don't want to use VarChar if possible;
If LONG is used, we need a way to read changes to the field to record changes and log them to history trail tables.

Thoughts, comments, issues we should be concerned with? Thanks in advance for advice,

Dixie Lang

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 01 1999 - 13:31:00 CDT