> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
