Am 22.12.2010 11:50, schrieb mivi71dk:

> 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.

Try it with:

WHEN 100 THEN cast('Fulført' as varchar(20) character set UTF8 )

Luc.