Field in load script shall contain Euro symbol - but corrupted

[#1]

Hi,

I try to add a field to my table that sorts money values into categories:

if(sum(OLI_TMP.TCV_REPORTED) < 0, 'TCV < 0€',if(sum(OLI_TMP.TCV_REPORTED) >=0 and sum(OLI_TMP.TCV_REPORTED) < 200000, 'TCV 0€ - 200.000€', 'TCV > 200.000€')) as OPP_TMP.TCV_REPORTED_GROUP

Problem is, that the euro signs are not displayed correctly, most likely because of the char set. How can I change this?

Thanks.

[maxgro · Accepted solution]

try with chr, in my pc I get € with

load

chr(8364) as euro

autogenerate 10;

I got it in a textbox with

=ord('€')