On Sep 24, 5:00*pm, "canaj...@gmail.com" <canaj...@gmail.comwrote:
i have php form on an apache server that sends an email and stores in
a mysql database once it is submitted
when someone enters a name with an accent over a letter it mangles the
text
for example
the user enters Montréal and the email i get ends up looking like
Montréal, it also stores it in the database this way
any ideas on what is happening here and how i can correct it?
thanks
This sounds like a character encoding mismatch between the database
and the HTMl pages. The most usual cause is the web page being
encoded as iso-8859-1 (which I believe is the default format for
Dreamweaver), and the database being in UTF-8, but any character
encoding mismatch will produce similar results. Make sure that both
your database and web pages are using the same encoding, these days
this generally should be UTF-8.
UTF-8 is the preferred encoding because a valid ASCII string is also a
valid UTF-8 string, giving good backward compatibility. It also
supports the full set of Latin alphabet accents and characters in a
uniform way, and will even support far eastern languages (albeit in a
way that's quite inefficient).