Problems with MySQL query (Version 5) on Colfusion 9

Hi,

I've got some problems on CF9 with few queries, it looks as if there was consersion type problem. (Drivers changes perhaps)

CF8 :                 SELECT IF(SUM(B.TOTALAMOUNT) IS NULL, "0.00", SUM(B.TOTALAMOUNT)) AS CA                  WHERE etc....

if i execute this query on CF8, the CA result is a string, on CF9 it's a binary.

So i've got to cast in the query to have the same result :

CF9 :                -  SELECT convert(IF(SUM(B.TOTALAMOUNT) IS NULL, "0.00", SUM(B.TOTALAMOUNT)), CHAR ) CA,                   WHERE etc....

Here my questions :

- Is it normal behaviour of CF9 ? may i forgot to add some parameters in Coldfusion Administrator (such Connection String or blob buffers size in the data source parameter) ?

- Is there an other way to resolve this problem ?

What 's more, when i use queryAddColumn(query1, columnName, type , Array) MSQL types seem not be the sames as in CF8 (Exemple :

CF8 : integer unsigned

CF9 : int unsigned)

I think this problem his linked to the first problem

Thanks a lot,

Ttroubat