Re: Long strings....

Hi,

With Centura, use Long String datatype because String is limited to 255 chars.

"Andreas Koch" <akoch_at_rbg.informatik.tu-darmstadt.de> a écrit dans le message news: 3A0D2BAC.E9738361_at_rbg.informatik.tu-darmstadt.de...
> Hi,
>
> i have an problem with long quoted strings.
>
> If i declare a column
> test : varchar2(250)
>
> everything works fine (with strings up to 250 chars).
>
> If i declare a column
> test : varchar2(1000)
>
> declaration works, but any SQL statement like
>
> update mytable set test='very long string with 400 chars ....';
> i get either "quoted string too long" (Sql Talk) error or the string
> is truncated to 254 chars (Toad).
>
> If i try to query such a column from my Centura app (select
> test from mytable into :sTest) , even if the stored string is
> shorter than 250 chars, i just get an empty result.
>
> So:
>
> How do i use strings longer than 254 chars?
>
>
>
> --
> Andreas
> Die letzten beissen die ersten.
>
Received on Mon Nov 13 2000 - 15:57:30 CST