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

From: Ulrik Hoffmann <ulrik.peter_at_hoffmann-kiel.de>
Date: 22 Nov 2000 20:04:26 GMT
Message-ID: <8FF4D825Dulrikpeterhoffmannki@127.0.0.1>

adolph_mendicant_at_my-deja.com wrote in <8vh64o$3vt$1_at_nnrp1.deja.com>:

>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.

Hi Adolph,

The Maximum for tabledata is 4000 bytes, in PL/SQL a varchar2 can be 32k. If you want to store larger strings in tables, you have to use clob or long.

BYe
Uli Received on Wed Nov 22 2000 - 14:04:26 CST