No, what I meant was:

what happens if you use:

CASE GIFTCARD_DETAIL.GCD_STATUS
WHEN 100 THEN cast('Fulført' as varchar(100) CHARACTER SET UTF8 )
^^^^^^^^^^^^^^^^^^
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

You did the charcater set in every when clause BUT the one for "Fulført"

Luc.