Re: [GENERAL] ascii to utf-8

2008-01-25 Thread Tom Hart
Ok, that did it. Thank you for the help. Tomasz Ostrowski wrote: On Wed, 23 Jan 2008, Tom Hart wrote: pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for encoding "UTF8": 0xc52f Try editing your dump-file and change the line which reads "SET client_encoding

Re: [GENERAL] ascii to utf-8

2008-01-24 Thread Tomasz Ostrowski
On Wed, 23 Jan 2008, Tom Hart wrote: >>> pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence >>> for encoding "UTF8": 0xc52f >> >> Try editing your dump-file and change the line which reads "SET >> client_encoding = 'SQL_ASCII';" to "SET client_encoding = 'LATIN1';" > > I trie

Re: [GENERAL] ascii to utf-8

2008-01-23 Thread Tom Lane
Tom Hart <[EMAIL PROTECTED]> writes: > Also, it's taking around an hour and a half for a message to go from my > computer to being posted on the list. Is there a problem with the > mailing list software? Yeah, every so often the PG mail servers get kinda clogged up. I pinged Marc about this inst

Re: [GENERAL] ascii to utf-8

2008-01-23 Thread Tom Lane
Tom Hart <[EMAIL PROTECTED]> writes: > Tommy Gildseth wrote: >> Try editing your dump-file and change the line which reads "SET >> client_encoding = 'SQL_ASCII';" to "SET client_encoding = 'LATIN1';" >> > I tried making the changes you specified with notepad, wordpad, gVim, > vim and emacs and i

Re: [GENERAL] ascii to utf-8

2008-01-23 Thread Tom Hart
Tommy Gildseth wrote: Tom Hart wrote: Hello everybody. I hope your week's going well so far. I built our data mine in postgreSQL around 3 months ago and I've been working with it since. Postgres is great and I'm really enjoying it, but I've hit a bit of a hitch. Originally (and against pgAdmi

Re: [GENERAL] ascii to utf-8

2008-01-23 Thread Tom Hart
Tommy Gildseth wrote: Tom Hart wrote: Hello everybody. I hope your week's going well so far. I built our data mine in postgreSQL around 3 months ago and I've been working with it since. Postgres is great and I'm really enjoying it, but I've hit a bit of a hitch. Originally (and against pgAdmi

Re: [GENERAL] ascii to utf-8

2008-01-23 Thread Tommy Gildseth
Tom Hart wrote: Hello everybody. I hope your week's going well so far. I built our data mine in postgreSQL around 3 months ago and I've been working with it since. Postgres is great and I'm really enjoying it, but I've hit a bit of a hitch. Originally (and against pgAdmin's good advice, duh!)

[GENERAL] ascii to utf-8

2008-01-23 Thread Tom Hart
Hello everybody. I hope your week's going well so far. I built our data mine in postgreSQL around 3 months ago and I've been working with it since. Postgres is great and I'm really enjoying it, but I've hit a bit of a hitch. Originally (and against pgAdmin's good advice, duh!) I set up the dat