SELECT 0 AS ID, SPACE(75) AS Name
UNION
SELECT ID, Name FROM kunde
ORDER BY Name
results an error:
Illegal mix of collations (latin1_swedish_ci,COERCILBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'
TMyConnetion.Options.Charset = latin1
Table format = latin1
Database = MySQL 5.0.18nt
MyDac = 4.30.0.10 for Delphi 7 (Test with Delphi 2006 have same result)
MySQL Query Browser makes no Error with the same query and returns a correct resultset
if i change the query to:
SELECT 0 AS ID, COERCIBILITY(SPACE(75) COLLATE latin1_swedish_ci) AS Name
UNION
SELECT ID, Name FROM kunde
ORDER BY Name
no error results.
But why must i change the query? There is no UTF8 format defined.
Bug of MyDac?
JB
