I had the same problem when upgrading v7.4 database to v8, SQL-ASCII to UTF8 - we had to replace single backslashes with double backslashes in the v7 database to get the data to display correctly, then dump and restore in v8 / UTF8. Have we done something wrong please?
PostgreSQL Admin wrote: > I had my database set to SQL_ASCII and switched to UTF8, but now I > notice that I must add a slash for periods/dots ( \. vs . ) to insert > into varchar. Is this normal?