Mitchell D. Russell escribió:
I did a PG_dump of the database tonight, and went to restore it to my newly
created database (WIN2152 encoding), which worked fine, but when I go to
retrieve the data via my code (.NET c#), I get errors like :
character 0x8f of encoding WIN1252 has no
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
Just as an update to this matter, I created another new database with
SQL_ASCII encoding and imported the data, and it worked fine, however, I
don't think that's the best solution because SQL_ASCII's not a good way to
have the database encoding set, right?
Thanks again for any suggestions.
On Sun, Mar 09, 2008 at 06:12:14AM -0400, Mitchell D. Russell wrote:
Just as an update to this matter, I created another new database with
SQL_ASCII encoding and imported the data, and it worked fine, however, I
don't think that's the best solution because SQL_ASCII's not a good way to
have
On 2008-03-09 01:45, Mitchell D. Russell wrote:
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
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean Gibson (DB
Administrator)
Sent: Sunday, March 09, 2008 9:58 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] v8.3 + UTF8 errors when restoring DB
Well, you partially hosed yourself when you did the dump using a
'client_encoding
On 2008-03-09 11:49, Mitchell D. Russell wrote:
Dean:
I did the dump as so: psql –Upostgres databasename c:\temp\dump.sql
I assume you meant pg_dump, not psql.
I think the database was set to SQL_ASCII before I dumped it, because
when I did the 2^nd restore last night to a new
On 09/03/2008 18:49, Mitchell D. Russell wrote:
I think the database was set to SQL_ASCII before I dumped it, because
when I did the 2^nd restore last night to a new SQL_ASCII database, it
worked fine, so that’s where I am at right now, the database is running
fine on 8.3 as SQL_ASCII but I
