Yazan: dp | 26 January 2010 | Comments
Categories: Uncategorized
I admit, I borrowed this from How to fix strange characters in MySQL database – Vinh Pham. But I also added a few more that were missing;
update <table> set <field> = replace(<field>, ‘’’, ‘\”);
update <table> set <field> = replace(<field>, ‘…’, ‘…’);
update <table> set <field> = replace(<field>, ‘–’, ‘-’);
update <table> set <field> = replace(<field>, ‘“’, ‘”‘);
update <table> [...]
