Re: Endian issue, BYTE columns and INFORMIX

>>>>> "JL" == Jonathan Leffler <jleffler@informix.com> writes: >> >> Given that we're able to fetch and store ordinary data types >> >> just fine, it appears that server-client software recognizes >> >> the difference in byte ordering between the two or uses some >> >> kind of XDR format but doesn't extend to BYTE or TEXT >> >> columns? JL> Can DB-Access show you the data in the column? HP's DB-Access and our HP client applications show the data in the column just fine. We don't have DB-Access for the Linux box yet. JL> I ran this without trouble on RedHat 6.2 (kernel 2.2.14-5smp, JL> glibc 2.1.3) with IDS 9.21 and CSDK 2.40 both on the Linux JL> box. Our Linux box has RH6.2 kernel 2.2.16-3smp, glibc 2.1.3 installed. JL> I added a line to print the text blob, and it gave the JL> correct answer. I don't have a database on an HP-UX box that JL> I can conveniently use. Have you tried the program running JL> solely on Linux? We don't have a server on Linux, but I'll see if we can download a trial copy from intraware. It will take some time to get this set up and running for this test. JL> Does it still crash? If it doesn't crash against a Linux JL> database but does against the HP one, there is a bug JL> somewhere. If it fails against the Linux database, then JL> we'll need What? What? :) >> Then we tried SQLCMD which was built on the Linux box: This is SQLCMD 57, BTW. >> >> % sqlcmd -d fxatext SQL[1]: select product from >> stdtextproducts; SQL -403: The size of a received row disagrees >> with the expected size. Memory fault (core dumped) JL> Ouch. >> We downloaded Client SDK 2.40 for Linux. Is this appropriate >> for the server we have? JL> Should be fine. I'll double check SQLCMD 57 on my Linux box JL> soon, but maybe not this week. Thanks for your time. I am trying to get a maintenance contract for the Linux Client SDK so I can open a case # on this, but the Vienna VA office is not returning my calls. (I want to throw money at them and they ignore me. Not good for business) Mark -- "A jury consists of twelve persons chosen to decide who has the better lawyer." -- Robert Frost