UPDATE `table` SET `column` = REPLACE(`column`, 0xE28098, "'"); UPDATE `table` SET `column` = REPLACE(`column`, 0xE28099, "'"); UPDATE `table` SET `column` = REPLACE(`column`, 0xE2809C, '"'); UPDATE `table` SET `column` = REPLACE(`column`, 0xE2809D, '"'); UPDATE `table` SET `column` = REPLACE(`column`, 0xE28093, '-'); UPDATE `table` SET `column` = REPLACE(`column`, 0xE28094, '--'); UPDATE `table` SET `column` = REPLACE(`column`, 0xE280A6, '...'); UPDATE `table` SET `column` = REPLACE(`column`, CHAR(145), "'"); UPDATE `table` SET `column` = REPLACE(`column`, CHAR(146), "'"); UPDATE `table` SET `column` = REPLACE(`column`, CHAR(147), '"'); UPDATE `table` SET `column` = REPLACE(`column`, CHAR(148), '"'); UPDATE `table` SET `column` = REPLACE(`column`, CHAR(150), '-'); UPDATE `table` SET `column` = REPLACE(`column`, CHAR(151), '--'); UPDATE `table` SET `column` = REPLACE(`column`, CHAR(133), '...');
Friday, February 3, 2012
Replace windows specials characters like curly quotes and ellipses in MySQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment