Thanks for the response,
I am looking at the Infomix PDF doc on sql syntax and it states:
"SIZE: The number of bytes in the char or nchar column: you must specify an
integer value between 1 and 32,767 bytes inclusive."
Hence I don't see how char(2500) is illeagal cause its way below 32K. It is
odd how i can do a successful column creation but when I insert into it it
gives -280 that the string exceeeds 256 bytes. Any ideas? Is there a admin
server config that overrides large user column specified sizes to save space?
thx
-aaz
At 03:46 PM 7/21/99 -0700, Binh Thanh Nguyen wrote:
>
>Hi,
>
>How did you define the field ?
>
>TEXT or CHAR ?. CHAR will not be able to accept anything larger than 255
chars.
>
>Hope that would help.
>
>Binh
>
>>
>> Hi,
>> We have an informix database option for CSG Systems.
>> The account for the database is "csgsyste" That is also the database name
>> and username for the database.
>>
>> Anyways, we have a few columns of char(2500) and up until yesterday it was
>> successfully accepting that amount of data. Today it is not. Well now even
>> after droping and re-creating the table with char(2500) we are now getting
>> error -280 back stating that the strings being inserted are greater than
>> 256 bytes.... what is going on? Did something change on the server?
>>
>> thanks!
>> -Aaz
>>
>>
>>
>> thx!
>>
>>
>>
>