Problem displaying special characters in UTF-8 encoding

Hi,
I’m having a problem with the display of special characters (©, ™, etc), the characters end up looking like this:

The page is written in PHP and encoded in UTF-8.

It pulls the content from a MySQL database. The database is a MyISAM type. The structure of the table of the content collation is ascii_general_ci. (I have tried it collated as utf-8, latin1_swedish_ci but it still doesn’t display correctly).

Our web server is running on PHP v5.4

I’ve run out of ideas as to why it won’t display properly.

Help!

Thanks!

Hello,
Have you indicated what character set the client will use to send SQL statements to the server?
SET NAMES 'charset_name' in your case if you have your db in UTF-8 then SET NAMES utf8
Just execute this command as any other SQL right after you have connected to the server.

1 Like

Hi Pavel,

I think that worked!

Thanks very much!