|Pathologically Eclectic Rubbish Lister|
Re: How to concatenate utf8 safely?by gregor42 (Parson)
|on Oct 25, 2016 at 13:22 UTC||Need Help??|
andal : " ... First of all, you have to worry about representation of characters in the octets that you receive from external applications. That depends on locale settings ... "
OP " ... I assume that the problem is my code and not the data coming in since one can usually depend on people to get their own names right ... "
It would appear that my initial assumption was incorrect. I challenged that & as it turns out what I am dealing with is a mixture of localized character sets taken as input from across Europe, cut & pasted between spreadsheets in an HR department spanning multiple offices.
These are conscientious people, mind you, who are concerned about getting the characters just right by potentially editing with multiple programs along the way...
I'm glad that I asked and should have done so sooner.
Now, in the proper mindset and having done my revision a big thing I was missing was that I was using :utf8 instead of :encoding(utf8) which allowed me to regain the trust factor in the data.
I had all kinds of stupid ideas and bad assumptions that led me to chase phantoms. Now at least I can identify mangled input on the way in.
Wait! This isn't a Parachute, this is a Backpack!