Am 22.12.2010 13:29, schrieb mivi71dk:

> I tried this:
>
> SELECT
> GIFTCARD_DETAIL.GCD_DATE,
> GIFTCARD_DETAIL.GCD_VALUE,
> GIFTCARD_DETAIL.GCD_POSNUMBER,
> GIFTCARD_DETAIL.GCD_STATUS,
> CASE GIFTCARD_DETAIL.GCD_STATUS
> WHEN 100 THEN cast('Fulført' as varchar(100) )
> WHEN 255 THEN cast('Annulleret' as varchar(100) CHARACTER SET UTF8)
> WHEN 250 THEN cast('Limbo' as varchar(100) CHARACTER SET UTF8)
> else cast('Ukendt' as varchar(100) CHARACTER SET UTF8)
> end as Status_Text
> FROM
> GIFTCARD_DETAIL
> Where
> GIFTCARD_DETAIL.GIFTCARD_ID = :ID
> Order by GIFTCARD_DETAIL.GCD_DATE
>
> Which still came up with the MALFORMED STRING

You did specify the character set in every column BUT the one with
"Fulført" in it.

On my side it works with:

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

(But it does also without, since I use WIN1252.

Luc.