Re: [ADMIN] Character encoding problems and dump import

2006-03-21 Thread ogjunk-pgjedan
SCII characters, but it didn't... not sure why. Otis - Original Message From: John DeSoi <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Sent: Tuesday, March 21, 2006 12:31:16 AM Subject: Re: [ADMIN] Character encoding problems and dump import On Mar 20,

Re: [ADMIN] Character encoding problems and dump import

2006-03-20 Thread John DeSoi
On Mar 20, 2006, at 3:21 PM, <[EMAIL PROTECTED]> [EMAIL PROTECTED]> wrote: The data may not be the cleanest, and I have limited control over that. But I am wondering if there is any way I can import this data, even if that means converting some of the characters into something else. incon

Re: [ADMIN] Character encoding problems and dump import

2006-03-20 Thread Ivo Rossacher
Am Montag, 20. März 2006 21.21 schrieb [EMAIL PROTECTED]: > Hello, > > I have a dump (non-binary, if it matters) of a DB that has some characters > in it that my DB doesn't want to take. I'm using PG 8.0.3 and it was > created with Unicode support: > > => \encoding > UNICODE This is the client enc

[ADMIN] Character encoding problems and dump import

2006-03-20 Thread ogjunk-pgjedan
Hello, I have a dump (non-binary, if it matters) of a DB that has some characters in it that my DB doesn't want to take. I'm using PG 8.0.3 and it was created with Unicode support: => \encoding UNICODE Characters that cause problems during the import are things like: é and other characters from