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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.