What's wrong with this MySQL trigger?

So what is wrong with this trigger? MySQL is only nice enough to tell me it is a 1064 error.

DELIMITER |

CREATE TRIGGER new_member BEFORE INSERT on member
FOR EACH ROW BEGIN
    INSERT INTO party(PartyId, PartyTypeCode, DateCrea开发者_高级运维ted, DateUpdated) 
     VALUES(New.PartyId, ’M’,now(), now());
END;
|

DELIMITER ;

---

I'd guess that your problem is the non-ASCII quotes in your VALUES:

VALUES(New.PartyId, ’M’,now(), now());
-- -----------------^

Try using plain old single quotes like SQL expects:

VALUES(New.PartyId, 'M', now(), now());