Special characters, encoding problems, how to prevent and solve.
I feel the urge to share this with everybody because the ever returning questions and errors regarding so called "special" characters and related problems. Read and learn, this is a must read... written by David C. Zentgraf he is a web developer working partly in Japan and Europe, thumbs up for taking the time to write this.
Its about encoding and how it works behind the scene, under the hood... every data-engineer should understand this. How encoding works
A good companion to this would be an article on "delimiters, separators, escaping, and line ends". A different topic, but similarly poorly understood by jobbing programmers who absolutely need to know better.
