为什么我的mysql数据库不接受重音标记?

I've just discovered an issue where city names that contain accent marks, e.g. La Cañada, Peñasco, etc., won't save to my database. Looking through the answers to another SO question, I've just discovered an issue where city names