>>In other words, why do you need to go to MySQL at all to get this result?
>
>Because it was Tuesday and that's the day I post pointless quesstions on UT.
>
>Because I simplified a different query to focus on what I considered a strange result. Would it really have mattered if I had posted

>SELECT < myFieldList including a bit field >

>and the bit field is Logical in the resulting cursor

>SELECT DISTINCT < myFieldList including a bit field >

>and the bit field is now Character

Can you try Fabio's alternative even for your complex case (e.g. put all fields into GROUP BY)?

I don't really use MySQL but I saw threads here that bit type comes as char before.