Re: field types possible with Oracle

From: David Ciesnik <ciesnik_at_ucsub.Colorado.EDU>
Date: 17 Nov 1998 23:25:28 GMT
Message-ID: <72t0l8$ntl@peabody.colorado.edu>

Robert Prell (RPrell_at_PacBell.Net) wrote:
: Does oracle support field types of;

: Binary/bit?

Yes, BLOb (Binary Large OBjects).

: Memo/text?

Yes, CHAR and VARCHAR. There is also TEXT. TEXT is similar to BLOb, in that you can't search on this field.

: Intiger?

Yes, INTEGER.

: If not what field types do you suggest I use. Also if anyone has a

                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Depends what type of data you intend to put into the attribute field. Integer for numbers, CHAR for characters of short or known lengths, VARCHAR for larger text fields which you don't know the length (helps save space), etc...

-Dave

-
David Ciesnik
ciesnik(at)ucsub(dot)colorado(dot)edu Received on Tue Nov 17 1998 - 17:25:28 CST