Hi all

I'm having trouble displaying special characters. I have a database that has a number of characters from different languages and I've managed to display almost all of them. But I still have some characters showing up as a question mark inside a diamond.

The code I'm using in my php script is as follows:

mysql_query("SET CHARACTER SET 'latin1'", $this->connection);
mysql_query("SET NAMES 'latin1'", $this->connection);
mysql_query("SET collation_connection = 'latin1_general_ci'");

Can anyone suggest what I can do to fix this? I'm pretty certain these characters are curly apostrophes/inverted commas.

Any help will be greatly appreciated.

8 Years
Discussion Span
Last Post by Venom Rush

What content type you have set for HTML page? Did you use utf-8?

Yes I set it to utf-8.

Solved the problem this morning. Seems that we just needed to paste the characters over the diamonds and update the records in order for them to display.

Everything seems to be displaying correctly now.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.