Retro Web Development: smart quotes

Showing posts with label smart quotes. Show all posts

Wednesday, June 05, 2013

Using SQL to Replace Smart Quotes and Other Special Characters

UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '’', '''')
UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '–', '--')
UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '“', '"')
UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '”', '"')
UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '…', '...')