RE: infromix

Wow Khanh, It's interesting that you even thing of that:). Well, the way I see it: 1) Check the data type 2) Check the field definition 3) Check the data set 4) Check the process 5) Write little SQL test scripts to work with test datafile 6) Use the same SQL statement in the program (check DBI-DBD, and or Informxix-DBD packages for dependencies ;) 7) Contact DBA last since they would not know about your process than anyone else 8) Verify the latest change in the server 9) Verify the latest change in the programming environment 10) Well, consultants ... where are they ? Binh -----Original Message----- From: Khanh Nguyen [mailto:ktnguyen@cerf.net] Sent: Thursday, July 22, 1999 5:03 PM To: aaz@leopard.com; nbt@cerf.net; informix-list@iiug.org Cc: dbhelp@lynxhub.lz.att.com; Michael Shindle Subject: RE: infromix Hi Aaz, I suspect you have "illegal" char in your sql string which cause the engine think the string does not have matching quote and treat it as unterminated string.. then it becomes longer than it supposes to be. Try to formulate your string outside the SQL statement with your desire length then substitue it to the SQL to see if you still have the same problem. Khanh At 05:39 PM 7/21/99 -0600, aaz@leopard.com wrote: >Thanks, >Well, thats the thing, I am using char(2500) not varchar. So thats why I'm >in confusion here as to why I am still getting that 256 byte limit thing. >Hence I suspect an admin setting that overrides or smthing? > >thanks! > > > >At 04:27 PM 7/21/99 -0700, Binh Thanh Nguyen wrote: >> >>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! >>>> >>>> >>>> >>> >> >