I would normally save this for a random links post, but it’s far too important for that. Joel has written the absolute minimum you need to know about unicode and character sets. I personally knew most of it (although UCS-2 was news to me), but I know how important this stuff will be in the future.
Get it learned if you want to work with computers in 10 years time. It’s really not that hard.