Code Pages versus Locales/Locale Names

The question recently came up on why someone’s index range on a text column wasn’t working properly. It turns out they forgot to set the Code Page on the column, but they were still storing Unicode data in the column. So the question came up about just what the heck is a Code Page. I…