busboy — 2012-11-29T18:50:06-05:00 — #1
When I designed my website 8 years ago I never thought that foreign people would register. Most of my users are from the US, Canada and Australia, however, there is a good number from other countries too. Some of their names, obviously, are not stored correctly in the DB because of the different characters that are used. I've done some research and switching to utf-8 is no small job. I'm wondering if it's worth the time and expense to implement. Anyone care to comment on their migration experience?
guido2004 — 2012-11-30T03:13:54-05:00 — #2
Can't tell you anything about migration to utf-8, but another (maybe simpler) solution you might consider (if the migration turns out to be too much work) is restricting the character set allowed for their name when registering. Obviously it's not the perfect solution, but if your database doesn't store characters like òçàù correctly, what's the point in allowing them to be used at all?
busboy — 2012-11-30T17:29:48-05:00 — #3
My DB uses Latin1 for the character set. I just tried pasting the special characters you used in your post and it worked. That's odd. I thought the DB had to be configured to use utf-8 to support foreign characters. What am I missing here?
r937 — 2012-11-30T18:36:12-05:00 — #4
the obvious answer is, those characters aren't "foreign"