Error on SELECT

Tuanonheb · Post by **Tuanonheb** » Thu 09 Mar 2006 12:30

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

Tuanonheb · Post by **Tuanonheb** » Thu 09 Mar 2006 12:56

With MyDac 3.55 results no error!

????

Please correct the Bug in 4.3

JB

Antaeus · Post by **Antaeus** » Fri 10 Mar 2006 09:50

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.