Problem displaying special characters in UTF-8 encoding

PHP
1

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!

2

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
3

Hi Pavel,

I think that worked!

Thanks very much!