HTML's escape characters giving errors

[George Dawson]

When doing an insert,

 INSERT INTO `recipe_recipes` VALUES 
(3,'37°F or purÉe') ;

I get an error. Why? And how do I get around it?
I am trying to insert the degrees character and the accented 'e'.

I have discovered that the CHAR(176) represents the degrees character, but how do I include that in a string in an INSERT statement?
'98.6'CHAR(176)'F'
will not work.

Any ideas?

Thanks



Edited 2 time(s). Last edit at 06/29/2007 08:13AM by George Dawson.