Re: Help me ! insert Long String
The error number is -280 and message is "A quoted string exceeds 256 bytes".
All characters of the string are alphabets;
The string length is 300 bytes .
If you are doing this within dbaccess try using the load command
load from "/path/to/filewithverylongstring.txt"
insert into test;
The filewithverylongstring.txt file should look like this:
123456789012345678901234567890.........12345678901234567890|
with a return character following the | delimiter.
HTH
----- Original Message -----
From: "Mark Oberfield" <oberfiel@eclipse.nws.noaa.gov>
Newsgroups: comp.databases.informix
Sent: Thursday, November 02, 2000 12:01 AM
Subject: Re: Help me ! insert Long String
> >>>>> " " == '''''' <seol@hotkey.to> writes:
>
> > I have made some tables that include char type column, and that
> > column length greater than 256byte.
>
> > So I want insert into a long string the column but the string
> > could not be inserted the table.
>
> > Example create table test (longchar char(500));
>
> > insert into test values
> > ('123456789012345678901234567890.........12345678901234567890');> > |_______________________________________________________| 300
> > Bytes
>
> > Could I insert this long string!!!!
>
> Provided that string had printable characters, you should be able to.
> What was the error message and numbers associated with the INSERT statement?
>
> Mark
> --
> "A man will fight harder for his interests than for his rights."
> -- Napoleon
Mark
--
"One word sums up, probably, the responsibility of any vice
resident, and that one word is: `to be prepared.'"
-- Dan Quayle