topic Euro Symbol in String Field Getting Converted to Â, in App Development

Euro Symbol in String Field Getting Converted to Â,

catalystmichael — Tue, 08 Aug 2017 08:13:48 GMT

When loading from CSV any text/string fields containing a Euro currency symbol are being converted to Â... as per below image.

I know I could resident load the CSV results and wrap the field in a replace function (replacing with chr(8364) ) but I'd rather tackle it at source and I'm sure there has to be a simpler way.

Any ideas?

Re: Euro Symbol in String Field Getting Converted to Â,

Gysbert_Wassenaar — Tue, 08 Aug 2017 09:19:32 GMT

Make sure you're using the right encoding when loading the data from the file. Perhaps it's an utf-8 file and you're loading it as ascii with codepage 1252 or it's the other way around.

utf-8: (txt, utf8, embedded labels, delimiter is ',', msq)

ascii: (txt, codepage 1252, embedded labels, delimiter is ',', msq)