Re: Long columns obsolete

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Sun, 07 Dec 2003 16:59:22 +0100
Message-ID: <nhj6tvojqok4nt2b0udomqja1l92amoneu@4ax.com>

On Sun, 7 Dec 2003 09:45:17 -0500, "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

>
>| Where does your 32787 come from - typo, I presume?
>|
>
>Apparently a typo, but not 32768 either...
>
>PL/SQL User's Guide, Fundamentals chapter:
>
>You use the VARCHAR2 datatype to store variable-length character data. How
>the
>data is represented internally depends on the database character set. The
>VARCHAR2
>datatype takes a required parameter that specifies a maximum size up to
>32767
>bytes.
>
>-- mcs
>

Yeah sure, but the VARCHAR2 *database* datatype only allows for 4000 characters.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Dec 07 2003 - 09:59:22 CST