MyDAC 5.10 strange data type result on mysql select constants
Posted: Wed 01 Aug 2007 03:48
On BDS 2006, MyDAC 5.10 and MySQL 4.1.16, when I open a query like "SELECT 1 AS a" I get returned field "a" in ftBoolean DataType !... In fact for any constant from 0 to 9 I get ftBoolean, but from 10 up the result is ftLargeInt. Example "SELECT 0 AS a, 5 AS b, 10 AS c", fields "a" and "b" are returned in ftBoolean, but field "c" is in ftLargeInt. I switched back to MyDAC 5.00, its ok and all fields are returned in ftLargeInt.
Have I missed any settings?
Thanks for any ideas.
Have I missed any settings?
Thanks for any ideas.