hello, i have a database and in it strings with accented characters in latin-1 encoding, but the database has been mistakenly created with unicode encoding. as you all know this makes pg_dump break. what i'm enquiring is - is there a way to change the encoding and preserve the data? i only know of one way to specify the encoding, initdb -e, but afaik that will nuke all the data also. and i can't use pg_dump, obviously... i'm using postgresql version 6.5.18. ps. i also get odd effects like strings with "ä" turning into "(e6)" at times, i suppose it's also related the incorrect encoding setting? -- erno
