Re: [ADMIN] Converting a DB from SQL_ASCII to UTF-8

2007-06-18 Thread Ivo Rossacher
There is no general answer to the question. It highly depends on how the data was entered. SQL_ASCII is not an encoding but more the absence of any encoding. So whatever the client sends will be put into the database. So if you entered data with different encodings from the client side (typicall

[ADMIN] Converting a DB from SQL_ASCII to UTF-8

2007-06-18 Thread Michael Monnerie
Dear list, how would I convert an existing database (dbmail mail server, http://dbmail.org/) from SQL_ASCII to UTF-8? I cannot just dump and reload, because: psql:/mnt/dbmail:191030: FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xdc62 TIP: Dieser Fehler kann auch auftreten, wenn die