Storing apostrophes, exclamation marks, etc. in mysql database

Posted by rein on Stack Overflow See other posts from Stack Overflow or by rein
Published on 2010-05-09T05:06:53Z Indexed on 2010/05/09 5:08 UTC
Read the original article Hit count: 210

Filed under:
|
|

I changed from latin1 to utf8. Although all sorts of text was displaying fine I noticed non-english characters were stored in the database as weird symbols. I spent a day trying to fix that and finally now non-english characters display as non-english characters in the database and display the same on the browser. However I noticed that I see apostrophes stored as ' and exclamation marks stored as !. Is this normal, or should they be appearing as ' and ! in the database instead? If so, what would I need to do in order to fix that?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database