Error on SELECT

Error on SELECT

Postby 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
 
Posts: 4
Joined: Tue 26 Jul 2005 14:11

Postby Tuanonheb » Thu 09 Mar 2006 12:56

With MyDac 3.55 results no error!

????

Please correct the Bug in 4.3

JB :)
Tuanonheb
 
Posts: 4
Joined: Tue 26 Jul 2005 14:11

Postby 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.
Antaeus
 
Posts: 2098
Joined: Tue 14 Feb 2006 10:14


Return to MySQL Data Access Components