Informix ODBC Driver

IDS 9.40.FC8X3 on Solaris 9 ODBC Driver 3.82.0000 2.81.TC2 If I run this query (via Business Objects) SELECT id, title, gender, fname, lname FROM customer WHERE id = 1234567890 and the fname column includes special characters all columns after fname are returned blank or random characters. If I move the fname column to the end of the column list all data is returned as expected. Has anyone seen this behaviour before? BTW We also get the same results using ODBC driver 2.90.TC4. Using a driver from Openlink works perfectly. Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ The next generation of Hotmail is here! http://www.newhotmail.co.uk

Have you try OLEDB driver ? "Colin Dawson" <cjd_1955@hotmail.com> wrote in news:mailman.500.1185359687.13675.informix-list@iiug.org: > IDS 9.40.FC8X3 on Solaris 9 > ODBC Driver 3.82.0000 2.81.TC2 > > If I run this query (via Business Objects) > > SELECT > id, > title, > gender, > fname, > lname > FROM > customer > WHERE > id = 1234567890 > > and the fname column includes special characters all columns after > fname are returned blank or random characters. If I move the fname > column to the end of the column list all data is returned as expected. > > Has anyone seen this behaviour before? > > BTW We also get the same results using ODBC driver 2.90.TC4. Using a > driver from Openlink works perfectly. > > > > Regards > > Colin > > There are 10 types of people in the world, those that understand > binary and those that don't > > _________________________________________________________________ > The next generation of Hotmail is here! http://www.newhotmail.co.uk >