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.
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)