Long strings....

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.