Re: limit of varchar2

From: ewong <ewong_at_ewong.com>
Date: Wed, 16 May 2001 23:56:07 -0700
Message-ID: <3B037606.75F1260B@ewong.com>

Varchar2(4000) limit is per column, not per row.

Zeyad S wrote:

> Folks,
> In Oracle documentation, specifically Application Developer's Guide,
> they mention the following:
>
> Varchar2(size) Variable for each row, up to 4000 bytes per row. consider
> the character ser(one-byte or multibyte) before setting size.
>
> My question is: is the 4000 bytes is really the maximum bytes per row or
> there is something misleading here? I tried it and create a table with
> more than two fields one with varchar2(4000) and the other with
> varchar2(200) without any problem. Also i inserted two records and
> retieved them without any problem.
>
> Am I missunderstanding something here? and when should i consider using
> CLOB datatypes?
>
> Thanks,
> Zeyad
Received on Thu May 17 2001 - 01:56:07 CDT