Easy data types question - free format text 
Author Message
 Easy data types question - free format text

Hi,

I'm converting an Access database into Oracle and need advice on suitable
data types to replace a memo field.

The maximum length I expect to see is about 4000 characters, however it is
free format text so I have to code it a little defensively.

I understand that the long type would be most suitable, however this is an
obsolete type according to the doco.

Can anyone help with a recommendation and of so are there limitations on the
use of the type recommended, particularly when using text searches in a
select statement using like clauses etc.

Thanks in advance,
Simon Rawson



Sun, 16 Feb 2003 12:07:19 GMT
 Easy data types question - free format text

Hi,

I'm converting an Access database into Oracle and need advice on suitable
data types to replace a memo field.

The maximum length I expect to see is about 4000 characters, however it is
free format text so I have to code it a little defensively.

I understand that the long type would be most suitable, however this is an
obsolete type according to the doco.

Can anyone help with a recommendation and of so are there limitations on the
use of the type recommended, particularly when using text searches in a
select statement using like clauses etc.

Thanks in advance,
Simon Rawson



Sun, 16 Feb 2003 12:33:13 GMT
 Easy data types question - free format text
Hi,

I'm converting an Access database into Oracle and need advice on suitable
data types to replace a memo field.

The maximum length I expect to see is about 4000 characters, however it is
free format text so I have to code it a little defensively.

I understand that the long type would be most suitable, however this is an
obsolete type according to the doco.

Can anyone help with a recommendation and of so are there limitations on the
use of the type recommended, particularly when using text searches in a
select statement using like clauses etc.

Thanks in advance,
Simon Rawson



Tue, 18 Feb 2003 12:36:00 GMT
 Easy data types question - free format text

Quote:

> Hi,

> I'm converting an Access database into Oracle and need advice on suitable
> data types to replace a memo field.

> The maximum length I expect to see is about 4000 characters, however it is
> free format text so I have to code it a little defensively.

> I understand that the long type would be most suitable, however this is an
> obsolete type according to the doco.

> Can anyone help with a recommendation and of so are there limitations on the
> use of the type recommended, particularly when using text searches in a
> select statement using like clauses etc.

> Thanks in advance,
> Simon Rawson

VARCHAR2 or CLOB.

HTH
--
===========================================
Connor McDonald
http://www.***.com/

We are born {*filter*}, wet and hungry...then things get worse



Tue, 18 Feb 2003 21:49:02 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Data Transfer from Long data type to SQL Server Text data type column

2. Data type for free form text

3. Easy Question Data Types

4. Easy Question Data Types

5. Data type for Rich Text Format ??

6. Newbie question about formatting the money data type.

7. Data in Excel format TYPE XLS Question

8. Newbie question about Text Data Type

9. Text data type question

10. Text data type-newbe question

11. formatting data for varchar(2) data type

12. Moving Text around in TEXT data types


 
Powered by phpBB® Forum Software