problem inserting text

[tonyw]

hi, just moved a site from one server to another. All goes well, apart from an issue with text fields in a mysql table. Whereby something like this -

INSERT INTO my_table VALUES (1, 1, 'Here's - some text', 0);

comes out as "Here?s ? some text" in the new database.

Messing with the Collation format seems to make no difference. What am I missing?

thanks
tony

[tomhath]

You need to escape the ' in Here's

[Savahn]

INSERT INTO 'my_table' VALUE (1, 1, "Here's - some text", 0);

[bradgrafelman]

As tomhath pointed out, the single quotes need to be escaped with a backslash. If you're inserting data from a PHP script, this could be accomplished using [man]mysql_real_escape_string/man