sql - CF10 concatenated mysql string as binary data -

sql - CF10 concatenated mysql string as binary data -

i'm working on moving site cf8 cf10 , came across wasn't expecting. mysql query has simple concatenate combine company id company name such:

select concat(co_coid, ' - ',co_company) idconame

on cf8, returns string can display value on cfselect.

998 - company 999 - company b

etc.

however, on cf10 when dump query it's showing binary info , have utilize tostring() on output.

i knew there gotchas required using tostring() when returning encrypted info weren't there before, i'm not sure why it's doing on simple string concatenation.

[update] can changed through connect string or other server wide setting? know can utilize tostring() on output, or cast() in query, server wide ideal. mysql server same server, there's no version alter there.

convert number string,

select concat(cast(co_coid char(15)), ' - ',co_company) idconame

mysql sql coldfusion coldfusion-10