Inserting Registered Trademark Symbol/Copyright Symbol into MySQL with PHP

Question

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.

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;

Comments

[j0k]

Which kind of random values?

[DaveP]

What character set is your db table using?

[Lèse majesté]

Where would the BOM come from? MySQL doesn't use BOM, so it wouldn't be inserted by MySQL. And if it comes from his code editor, it would be the first character in his source code, which wouldn't be able to find its way into the database.

[Robert H]

I had similar issues trying to insert the registered trademark symbol, I was getting an incorrect string value from MySQL with the BOM listed. The data being passed to MySQL is the origination of the issue, but the issue is being reported in MySQL.

[dianovich]

What about when we don't want to output results as HTML?