After reading this, I did a search for mentions of this article and found this StackOverflow gem. The top answer basically picks up where the JoelOnSoftware article leaves off and filled in the rest of the blanks for me.

https://stackoverflow.com/questions/2241348/what-are-unicode...

Still have more reading to do and a lot to learn but this was super informative, so thank you internet stranger.