Posted by Michael Price on 06/13/07 10:30
Thank you to both of your for your replies. Via switching to the
HTMLMimeMail class and using the content-type headers suggested, my
HTML and plain text e-mails are now echoing the characters correctly.
My database problem, however, remains. Even after using "SET NAMES
utf8" I'm having the same problem - as I understand it this should be
the first query I execute after establishing the connection? Should I
be using any specific collation (the table is latin1_swedish_ci at the
moment) - I'm guessing it should be switched to UTF-8?
Final question, is there any way to retrieve old data from the
database (which is broken in the same fashion) and restore it to the
correct Unicode values?
Thanks again for the rapid responses.
Regards,
Michael Price
[Back to original message]
|