Oracle-L: Re: REF: Re: V7 VARCHAR2/CHAR usage

From: Eclipse Technology Inc. <0006410539_at_MCIMAIL.COM>
Date: Tue, 14 Mar 1995 07:43:00 EST
Message-Id: <9503141308.AA29491@alice.jcc.com>

The biggest reason to use VARCHAR2 is that it is the only "character" data type which is promised to be supported in the future. Oracle created these data types as a response to ANSI standards and potential standards for SQL, I believe.

One big point to remember with VARCHAR2 fields, if the maximum size is <= 250 bytes then it requires only 1 length byte. > 250 bytes and it requires 2. Doesn't sound like much but in some cases it could be.

Regards,
Powel Crosley
Eclipse Technology, Inc.
6410539_at_mcimail.com Received on Tue Mar 14 1995 - 08:08:31 CST