Devart Forums

I have just updated from 3.4 to 6.1 and after that some queries returns mysterious data ex

SELECT kp.Number, kp.name, concat(kp.number,' - ',kp.name) as Total FROM …

The two first data is correct but the third returns Byte[] Array or in some cases System.Byte[]

What is going wrong?

Well, I have found a way around the problem:

If I change

SELECT kp.Number, kp.name, concat(kp.number,' - ',kp.name) as Total FROM …

to

SELECT kp.Number, kp.name, CAST(concat(kp.number,' - ',kp.name) as CHAR) as Total FROM …

the bug disappear.

We have answered you by e-mail.