Re: problem: Postgresql and Unicode

> But now I'm facing another problem:
> How do I convert existing data in an SQL_ASCII database to unicode?
>
> Has anyone tried this before?

Yes, that is no problem. Have a look at
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=multibyte.ht
ml#AEN21920

short: dump sql_ascii, create unicode db, insert the dump with client
encoding set to latin1 (or whatever).

Regards,
Bjoern