mysterious data returned from query

mysterious data returned from query

Postby 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

Postby 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.
PEN
 
Posts: 2
Joined: Tue 27 Sep 2005 09:15
Location: Denmark

Postby Shalex » Tue 10 May 2011 15:24

We have answered you by e-mail.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL