score:0

You can convert the trademark, copyright or other symbols into/out database via an HTMLEntity

The htmlentities() function converts characters to HTML entities.

Reference: http://www.php.net/manual/en/function.htmlentities.php

Reference: http://www.php.net/manual/en/function.htmlspecialchars.php

® Registered Trademark ®

™ Trademark Symbol: ™

Other useful information and symbols can be found here: http://www.w3schools.com/html/html_entities.asp

score:1

You can use html character entities instead of direct symbol

Do not use

®

Try it

®

score:1

These types of encoding issues can get complex when dealing with different character sets. In these cases, just changing the collation will not fix the problem, you need to change the CHARSET. Only after changing the CHARSET should you worry about the collation (they are not the same thing).

Just to be safe, export your database/table before altering it.

I would begin, by converting the table to utf8 since it is now the standard.

ALTER TABLE tbl_name
CONVERT TO CHARACTER SET utf8

By doing this, it will also change the CHARSET of the table and columns to utf8, but you may still need to manually change the collation of the columns to utf8_general_ci (seems like you have already done that).

In the event you want to change the default character set (for new columns)...

ALTER TABLE tbl_name
DEFAULT CHARACTER SET utf8

EDIT :
If changing the CHARSET in the database doesn't work, you can try setting it on the PHP side. Just add this after your connection.

mysql

mysql_set_charset("utf8");

mysqli

$mysqli->set_charset("utf8");

PDO

PDO::MYSQL_ATTR_INIT_COMMAND => "SET CHARACTER SET 'utf8'"

Here is some helpful documentation:

10.1 Character Set Support
10.1.12 Column Character Set Conversion
10.1.13.1 Unicode Character Sets


More questions

More questions with similar tag