Re: SQL Command - Insert string within the quotation mark limits to 2000 charater

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Command - Insert string within the quotation mark limits to 2000 charater

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Tue, 25 Sep 2001 00:55:45 +0100
Message-ID: <9ookut$4qg$1@phys-ma.sol.co.uk>

As of Oracle 8 you can have a varchar2 column of 4000 characters. You might also consider using a LONG column instead. Please give version info when presenting problems especially if you know you are using a de-supported version of Oracle

hth
Lawrence

"Ricky W.K.Lo" <lowk_at_mindware.com.hk> wrote in message news:9onl6g$67q7_at_rain.i-cable.com...
> As the tile.
>
> Who knows how to overcome this problems --->
>
> Insert into TABLE (Field1, Field2........) (Value 'Charaters more than
> 2000');
>
> Tks/B.Rgds, Ricky
>
>
Received on Mon Sep 24 2001 - 18:55:45 CDT