Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie datatype question

Re: newbie datatype question

From: Jared Hecker <jared_at_pandora.planet.net>
Date: 21 Aug 1998 12:35:45 GMT
Message-ID: <6rjpj1$g8@jupiter.planet.net>


VARCHAR is an obsolete datatype. Don not use it. Instead, use CHAR for text fields <=5 characters and VARCHAR2 for anything greater.

hth -

Regards,
jh

Eleanor LeClair (eleclair_at_gnossos.com) wrote:
: Hi all,
: I'm using Erwin to model with Oracle 8 (I have no access to Oracle 8 at
: the moment). What is the difference between the datatypes VARCHAR and
: VARCHAR2? Also, what datatype should I use for Logical or bit
: (True/False)?

: Thanks for the help.
: Eleanor LeClair

--

Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **
Received on Fri Aug 21 1998 - 07:35:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US