Hi,

I need to translate an utf8 value in a varchar field to WIN1252

using fb 1.53 or fb 2.0.3

This works oke:

select cast((_unicode_fss 'Möbel') as char(10) character set
WIN1252) from rdb$database;

you get Möbel


But this is not working when you have the value from a field:

select cast((_unicode_fss ORDERREFERENTIE) as char(10) character set
WIN1252) from TBL_ORDER WHERE ORDERNUMMER='1481351-1'

you get

*** IBPP::SQLException ***
Context: Statement::Prepare(
select cast((_unicode_fss ORDERREFERENTIE) as char(10) character set
WIN1252) from TBL_ORDER WHERE ORDERNUMMER='1481351-1' )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, char 27
ORDERREFERENTIE


Any Thought's on this ?

Regards,
Derryck