[GENERAL] v8.3 + UTF8 errors when restoring DB

2008-03-09 Thread Mitchell D. Russell
New to the list, so please forgive me in advance :) I've been running 8.2 on windows server 2003 for quite some time now. The database that I take care of stores records with various languages in it (russian, chinese, etc) and has been working fine. I did a PG_dump of the database tonight, and

Re: [GENERAL] v8.3 + UTF8 errors when restoring DB

2008-03-09 Thread Mitchell D. Russell
. Mitch From: Mitchell D. Russell [mailto:[EMAIL PROTECTED] Sent: Sunday, March 09, 2008 5:46 AM To: 'pgsql-general@postgresql.org' Subject: v8.3 + UTF8 errors when restoring DB New to the list, so please forgive me in advance :) I've been running 8.2 on windows server 2003 for quite

Re: [GENERAL] v8.3 + UTF8 errors when restoring DB

2008-03-09 Thread Mitchell D. Russell
Dean: I did the dump as so: Psql –Upostgres databasename c:\temp\dump.sql I think the database was set to SQL_ASCII before I dumped it, because when I did the 2nd restore last night to a new SQL_ASCII database, it worked fine, so that’s where I am at right now, the database is