Hi

I have D2010 and IBO 4.9.9.
I have a Firebird 2.1 DB. Its SQL Dialect 3, Charater set UTF8.


When I try to do this SQL in a TIBOQuery

SELECT
GCD.GCD_DATE,
GCD.GCD_VALUE,
GCD.GCD_POSNUMBER,
GCD.GCD_STATUS,
CASE GCD.GCD_STATUS
WHEN 100 THEN cast('Fulført' as varchar(20) )
WHEN 255 THEN cast('Annulleret' as varchar(20) )
WHEN 250 THEN cast('Limbo' as varchar(20) )
else cast('Ukendt' as varchar(20) )
end as Status_Text
FROM
GIFTCARD_DETAIL GCD
Order by GCD.GCD_DATE


I get a "Malformed string".
If I change the Fuldført to Fuldfort it works.

My TIB_Connection has CharSet set to UTF8.

What am I doing wrong here?