On Thursday 16 July 2009 10:53:37 Massa, Harald Armin wrote:
> Hello,
>
> I have an old PostgreSQL Database which was created with encoding =
> SQL_ASCII. That is an old sin of mine; 9years ago I did not know better.
>
> Now I know better than to use SQL_ASCII.
>
> On the bright side: I am totally sure that the TEXT within that database is
> in WIN1252 / CP1252 encoding.
>
> Is there any way to overwrite the encoding-information? something like
> "udpate <specialsystemcatalog> set pg_encodingcol='xxx' where
> databasename='oldsin';
Would a dump+reload work?
Andres