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.