Re: [GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Mike Christensen
On Thu, Jul 1, 2010 at 10:07 AM, Sam Mason wrote: > On Thu, Jul 01, 2010 at 10:01:02AM -0700, Mike Christensen wrote: >> Yup, the problem is line 170 doesn't actually match up to the >> DB.dbs.out file line 170 (which is a blank line).  I believe it means >> line 170 from the stdin pipe it was pro

Re: [GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Sam Mason
On Thu, Jul 01, 2010 at 10:01:02AM -0700, Mike Christensen wrote: > Yup, the problem is line 170 doesn't actually match up to the > DB.dbs.out file line 170 (which is a blank line). I believe it means > line 170 from the stdin pipe it was processing for the copy command. Doh, that's annoying. It

Re: [GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Mike Christensen
On Thu, Jul 1, 2010 at 9:54 AM, Sam Mason wrote: > On Thu, Jul 01, 2010 at 09:47:03AM -0700, Mike Christensen wrote: >> On Thu, Jul 1, 2010 at 9:44 AM, Sam Mason wrote: >> > On Thu, Jul 01, 2010 at 09:31:12AM -0700, Mike Christensen wrote: >> >> Then, I edited the file in Notepad and saved it as

Re: [GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Sam Mason
On Thu, Jul 01, 2010 at 09:47:03AM -0700, Mike Christensen wrote: > On Thu, Jul 1, 2010 at 9:44 AM, Sam Mason wrote: > > On Thu, Jul 01, 2010 at 09:31:12AM -0700, Mike Christensen wrote: > >> Then, I edited the file in Notepad and saved it as UTF8 which also > >> appears to have worked. > > > > I

Re: [GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Mike Christensen
On Thu, Jul 1, 2010 at 9:44 AM, Sam Mason wrote: > On Thu, Jul 01, 2010 at 09:31:12AM -0700, Mike Christensen wrote: >> Then, I edited the file in Notepad and saved it as UTF8 which also >> appears to have worked. > > I don't think you want to be doing this. The file should contain a "set > client

Re: [GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Sam Mason
On Thu, Jul 01, 2010 at 09:31:12AM -0700, Mike Christensen wrote: > Then, I edited the file in Notepad and saved it as UTF8 which also > appears to have worked. I don't think you want to be doing this. The file should contain a "set client_encoding" of the correct value which will let PG to do the

Re: [GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Mike Christensen
On Thu, Jul 1, 2010 at 10:22 AM, Justin Graf wrote: > > > On 7/1/2010 11:08 AM, Mike Christensen wrote: >> I'd like to convert a small database to UTF8 before it becomes too >> large.  I'm running on 8.3.x on Windows.  It doesn't seem that pgAdmin >> has any native way of doing this, what's the ea

Re: [GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Mike Christensen
On Thu, Jul 1, 2010 at 9:31 AM, Mike Christensen wrote: > On Thu, Jul 1, 2010 at 10:22 AM, Justin Graf wrote: >> >> >> On 7/1/2010 11:08 AM, Mike Christensen wrote: >>> I'd like to convert a small database to UTF8 before it becomes too >>> large.  I'm running on 8.3.x on Windows.  It doesn't seem

Re: [GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Justin Graf
On 7/1/2010 11:08 AM, Mike Christensen wrote: > I'd like to convert a small database to UTF8 before it becomes too > large. I'm running on 8.3.x on Windows. It doesn't seem that pgAdmin > has any native way of doing this, what's the easiest way to go about > doing this? Thanks! > > Mike >

[GENERAL] Easy way to convert a database from WIN1252 to UTF8?

2010-07-01 Thread Mike Christensen
I'd like to convert a small database to UTF8 before it becomes too large. I'm running on 8.3.x on Windows. It doesn't seem that pgAdmin has any native way of doing this, what's the easiest way to go about doing this? Thanks! Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresq