PostgreSQL. French HTML codes to RAW

fr_html_raw.sql

UPDATE my_table SET my_column=replace(my_column, 'À', 'À');
UPDATE my_table SET my_column=replace(my_column, 'Â', 'Â');
UPDATE my_table SET my_column=replace(my_column, 'Ç', 'Ç');
UPDATE my_table SET my_column=replace(my_column, 'È', 'È');
UPDATE my_table SET my_column=replace(my_column, 'É', 'É');
UPDATE my_table SET my_column=replace(my_column, 'Ê', 'Ê');
UPDATE my_table SET my_column=replace(my_column, 'Ë', 'Ë');
UPDATE my_table SET my_column=replace(my_column, 'Î', 'Î');
UPDATE my_table SET my_column=replace(my_column, 'Ï', 'Ï');
UPDATE my_table SET my_column=replace(my_column, 'Ô', 'Ô');
UPDATE my_table SET my_column=replace(my_column, 'Œ', 'Œ');
UPDATE my_table SET my_column=replace(my_column, 'Ù', 'Ù');
UPDATE my_table SET my_column=replace(my_column, 'Û', 'Û');
UPDATE my_table SET my_column=replace(my_column, 'Ü', 'Ü');
UPDATE my_table SET my_column=replace(my_column, 'Ÿ', 'Ÿ');
UPDATE my_table SET my_column=replace(my_column, 'à', 'à');
UPDATE my_table SET my_column=replace(my_column, 'â', 'â');
UPDATE my_table SET my_column=replace(my_column, 'ç', 'ç');
UPDATE my_table SET my_column=replace(my_column, 'è', 'è');
UPDATE my_table SET my_column=replace(my_column, 'é', 'é');
UPDATE my_table SET my_column=replace(my_column, 'ê', 'ê');
UPDATE my_table SET my_column=replace(my_column, 'ë', 'ë');
UPDATE my_table SET my_column=replace(my_column, 'î', 'î');
UPDATE my_table SET my_column=replace(my_column, 'ï', 'ï');
UPDATE my_table SET my_column=replace(my_column, 'ô', 'ô');
UPDATE my_table SET my_column=replace(my_column, 'œ', 'œ');
UPDATE my_table SET my_column=replace(my_column, 'ù', 'ù');
UPDATE my_table SET my_column=replace(my_column, 'û', 'û');
UPDATE my_table SET my_column=replace(my_column, 'ü', 'ü');
UPDATE my_table SET my_column=replace(my_column, 'ÿ', 'ÿ');