Re: Informix ODBC Driver

Hi, What is the column fname being defined as ? Is it a char or a varchar ? or ... It will be helpful if you can give the schema of the whole customer table. And when you say special characters ? are they simple special characters like $%^& or UNICODE characters. Give the sample data which are there in the fname column. Thanks Prem "Colin Dawson" <cjd_1955@hotmail .com> To Sent by: informix-list@iiug.org informix-list-bou cc nces@iiug.org Subject Informix ODBC Driver 25/07/2007 16:04 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 _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list