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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables