Re: infromix

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! >> >> >> >