Posting characters like ® and ™ to a mySQL DB from PHP
Posted: Mon Sep 11, 2006 11:02 am
When I Post characters like ® and ™ to a SQL database from a PHP edit page ie:
The resulting entry ends up being " ® " and " ™ ", but when I take the SQL statement:
and enter it into the database using phpMyAdmin the data is entered correctly, " ® ™ ".
Does anyone know how to eliminate this problem?
Thanks in advance
Tom
Code: Select all
SQL string = INSERT INTO products (cat_id,product,pict,pict_path,description,notes,pl_no,web_no,settings,features,specs,pb,drawing,opt_acc,w_order,a_order,new) VALUES ("64","® ™ reg\'d","","","","","","","31","","","","","","","","")Code: Select all
INSERT INTO products (cat_id,product,pict,pict_path,description,notes,pl_no,web_no,settings,features,specs,pb,drawing,opt_acc,w_order,a_order,new) VALUES ("64","® ™ reg\'d","","","","","","","31","","","","","","","","")Does anyone know how to eliminate this problem?
Thanks in advance
Tom