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.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.