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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema