DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Replace Weird Characters In MySQL

  • submit to reddit
        Replace weird characters in MySQL database (usually caused by copy/paste from a Microsoft product)

update <table_name> set <table_field> = replace(replace(replace(replace(replace(replace(replace(replace(<table_field>,'’', '\''),
'…', '...'),'–', '-'),'“', '"'),'”', '"'),'‘', '\''),'•', '-'),'‡', 'c');