RE: infromix

My apology, It's true that CHAR take up to 32,767 (ONLINE) or (32,511 for SE). It's however that if you use VARCHAR data the variable string is only 255 or 254 if the column is indexed. VARCHAR (<max length> [, <reserve length>]), HOPE THIS WILL REALLY HELP;) Binh PS: I will not be able to further entertain you since I am about to confuse even more people... -----Original Message----- From: aaz@leopard.com [mailto:aaz@leopard.com] Sent: Wednesday, July 21, 1999 4:26 PM To: Binh Thanh Nguyen; informix-list@iiug.org Cc: dbhelp@lynxhub.lz.att.com; Michael Shindle Subject: 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! >> >> >> >