
Partner - Contributor III
2017-08-08
04:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Euro Symbol in String Field Getting Converted to Â,
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?
1,637 Views
1 Reply

Partner - Champion III
2017-08-08
05:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
talk is cheap, supply exceeds demand
1,520 Views
