troubleshooting Question

PHP/MYSQL - Insert degree Symbol

Avatar of laurin1
laurin1Flag for United States of America asked on
PHPMicrosoft IIS Web ServerMySQL Server
34 Comments1 Solution2926 ViewsLast Modified:
I am trying to update a field, and the query looks like this:

UPDATE form_fce_his SET `history_medications`='test 2323°' WHERE id=26

However, what gets sent to the mysql server is this:

UPDATE form_fce_his SET `history_medications`='test 2323°' WHERE id=26

Any idea what might be causing this? I checked the query right before it was sent to the server, and it was correct. However, if I email myself that same query, I get the bad one, like what is sent to the server. At some point, it seems that PHP is modifying it, but I don't know where, or how to fix it. I can send the correct SQL to the mysql server manually, and it works fine.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 34 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 34 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros