Re: Newbie Question: How long can a varchar be?

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Wed, 22 Nov 2000 19:55:49 GMT
Message-ID: <3a1c2466.155829171@news.alt.net>

On Wed, 22 Nov 2000 19:17:46 GMT, adolph_mendicant_at_my-deja.com wrote:

>I'm using 8000 byte varchars on SQLServer, but I get an error from
>Oracle 8i when I try to create them. The error is "ORA-00910". I
>can't find anything in the docs that came with the trial CD or on the
>Oracle site that mentions the maximum length of a varchar.
>

From Oracle docs/SQL Reference/Data Types:

VARCHAR2(size)
Variable-length character string having maximum length size bytes. Maximum size is 4000, and minimum is 1. You must specify size for VARCHAR2. HTH,
Brian Received on Wed Nov 22 2000 - 13:55:49 CST