mysterious data returned from query

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
PEN
Posts: 2
Joined: Tue 27 Sep 2005 09:15
Location: Denmark

mysterious data returned from query

Post by PEN » Fri 06 May 2011 09:21

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?

PEN
Posts: 2
Joined: Tue 27 Sep 2005 09:15
Location: Denmark

Post by PEN » Mon 09 May 2011 18:47

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 10 May 2011 15:24

We have answered you by e-mail.

Post Reply