Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Most suitable data type
Simon,
If you are not farmiliar with Oracle, then the best datatype to use is a varchar2(4000). 4000 bytes is the max in this datatype. As long as you are using a standard character set then each character only uses 1 byte. When you get to Chinese etc. it uses 2 bytes per character.
You could use a CLOB, in which you can store up to 4Gig. These are not the easiest of datatypes to use if you are not familiar with Oracle.
LOB's have really replaced LONG and Oracle advise converting to LOB's.
Steve
"Simon Rawson" <simon_at_microz.com.au> wrote in message
news:39af23b5$0$26532$7f31c96c_at_news01.syd.optusnet.com.au...
> 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
>
>
Received on Fri Sep 01 2000 - 07:27:58 CDT