pg_chardetect

A PostgreSQL extension to detect the character set of a character-based column and change it to UTF8.