Our web server’s character set is ISO-8859 – 1. This has caused some problems when persons input accented characters or other non-ASCII characters into our database. Well, actually the problems occurred when the information was parsed to a webpage.
I’ve tried fixing this several times, but could not figure out how to set the character set on my MySQL tables to ISO-8859 – 1. Until today.
It seems the MySQL equivalent of ISO-8859 – 1 is ‘latin1’. I simply set the tables’ character sets to ‘latin1’, and voilà! Now I have all my accented characters.
Just thought I’d share in case others have the same problem.
Like this post? Sign up for monthlyupdates!
Did you like this post? Sign up to receive monthly writing and socail media tips.