Page 1 of 1

Error on SELECT

Posted: Thu 09 Mar 2006 12:30
by Tuanonheb
This query:
SELECT DATE_FORMAT('2006-01-01','%m %Y')

result this error:
Result +1 >= MaxDestBytes, Result = 6, MaxDestBytes = 6 (...\MyClasses.pas, Zeile(Row) 3551)

??????

Database MySQL 5.0.18nt
MyDac 4.30.0.10 for Delphi 7

MySQL Query Browser returns a correct result and no error


JB :)

Posted: Thu 09 Mar 2006 12:56
by Tuanonheb
With MyDac 3.55 results no error!

????

Please correct the Bug in 4.3

JB :)

Posted: Fri 10 Mar 2006 09:50
by Antaeus
This is MySQL Server bug. It's related to using property UseUnicode=True. Server returns wrong field length in this mode. Unfortunately we can't fix this bug.