Re: [GENERAL] overwrite the encoding of a database

2009-07-16 Thread Andres Freund
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

[GENERAL] overwrite the encoding of a database

2009-07-16 Thread Massa, Harald Armin
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.