Inserting Registered Trademark Symbol/Copyright Symbol into MySQL with PHP

database, html, mysql, php, sql

Solution

You can look into converting the copyright/trademark symbol from and into an HTMLEntity in order to ease data transfer to the database.

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

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

© Copyright Symbol: `&#169`;

™ Trademark Symbol: `&#153`;

Problem

I am having a hard time understanding how to insert the registered trademark sybol and copyright symbol to my mySQL database using php. When I insert the normal character of the reistered trademark symbol, it returns some random values when I try to retrieve it.

Original source