utf8 encoding: Can I really have it all?
I'm developing my first application that will have some non-English characters and I've been investigating the world of encoding. My accented characters look fine in my web application both before and after putting them in the database, but the actual database characters don't look as they should. On the one hand, I don't see this as a problem (I can only assume that my database understands that it's UTF-8, converts it to latin1, then converts it back to UTF-8 when I call for the data); however, it would be nice if I could have the data appear clean in both place.
After doing do some googling, I found that I can change a table's encoding as:
ALTER TABLE table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
However, after doing so, I had the opposite problem: manually entering accented characters in the database gave me junk on the screen (php's mb_detect_encoding() showed that my application is in fact using utf8 encoding() for the accented characters).
Any help in getting my characters to look correct in both places would be great.
Thanks so much,