Just finished reading Joels excellent article on Unicode and Character sets, buts its left me with a feeling that I don't fully understand the subject. Can you point me to other good articles that might explain in a different way/different angle? I want a solid understanding in this subject as it appears a lot of problems are caused because of encoding problems.
You might find this answer of mine on StackOverflow useful. At first, I felt the same way as you did: information available on the web was not so clear. I then sat down and thought about encoding issues, and only then understood that it's all based on a couple of simple principles. Hope this helps!