When importing a website (which contains euro signs) I get wrong data

[#1]

Hi,

I am importing data from a website (http://nl.wikipedia.org/wiki/Lijst_van_minimumloon_per_land), it's Dutch but it is imported fine

easy one:

LOAD
    Land,
    "Minimumloon in EUR" as euro

FROM [lib://Wikipedia]
(html, codepage is 1252, embedded labels, table is @1);

only the result remains:

â,¬ 94,79 instead of € 94,79

I already tried some

load

chr(8364) as euro

autogenerate 10;

and & chr(10) options, but no luck so far...

[Alexander_Thor · Accepted solution]

When you load the data make sure you have the Character Set set to Unicode (UTF-8) and the euro signs should load ok.

Or just change the connection string manually to (html, UTF8, embedded labels, table is @1);

[#3]

It works fine, thanks!