Fixing messed charset in SQL tables

This should be rare but if, when upgraded, extended characters are messed (e.g. á instead of á) here's a procedure to fix them manually. I've only tested it with an UTF-8 console though.

• Export offending tables (oldrecorded, oldprogram, program¹⁾, record and recorded most probably). Keep a copy of the exported files just in case.
• Apply fixing script found below. Requires bash and iconv
• DROP the tables
• Re-import them

Notes

• Add any extra non-English character used in your language to the CHARS line
• Save in UTF-8

#!/bin/bash
set -e

CHARS=( á é í ó ú à è ì ò ù Á É Í Ó Ú À È Î Ò Ù ñ Ñ · ¿ ¡ ä ë ï ö ü Ä Ë Ï Ö Ü ç Ç € ¢ £ ¥ ŀ ß æ œ )
TABLES=( oldrecorded oldprogram program record recorded )

echo "Translations:" >&2
for char in ${CHARS[*]}; do
	broken=$(echo $char | iconv -flatin1 -tutf8)
	char=$(echo $char | iconv -tutf8) # For non-UTF-8 systems (not tested)
	echo "$broken -> $char" >&2
done

for table in ${TABLES[*]}; do
	if [ ! -f $table.sql ]; then
		echo "Table $table skipped" >&2
	continue ; fi

	echo "Fixing $table" >&2
	for char in ${CHARS[*]}; do
		broken=$(echo $char | iconv -flatin1 -tutf8)
		char=$(echo $char | iconv -tutf8) # For non-UTF-8 systems (not tested)
		sed -i "s/$broken/$char/g" $table.sql
	done
done