Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-28 Thread Jasen Betts
On 2011-01-24, Geoffrey Myers li...@serioustechnology.com wrote: Adrian Klaver wrote: Thanks for the suggestion. As it stands, we are getting different errors for different hex characters, thus the solution we need is the ability to identify the characters that won't convert from SQL_ASCII

[GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Geoffrey Myers
We need to change the database encoding on our databases as they were created with the wrong encoding. They were created as SQL_ASCII and we are changing them to UTF8. When testing this Friday, I received the following error: pg_restore: [archiver (db)] Error while PROCESSING TOC:

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Adrian Klaver
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote: We need to change the database encoding on our databases as they were created with the wrong encoding. They were created as SQL_ASCII and we are changing them to UTF8. When testing this Friday, I received the following error:

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Geoffrey Myers
Adrian Klaver wrote: On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote: We need to change the database encoding on our databases as they were created with the wrong encoding. They were created as SQL_ASCII and we are changing them to UTF8. When testing this Friday, I received the

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Adrian Klaver
On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote: Adrian Klaver wrote: On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote: We need to change the database encoding on our databases as they were created with the wrong encoding. They were created as SQL_ASCII and we are

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Geoffrey Myers
Adrian Klaver wrote: On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote: Adrian Klaver wrote: On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote: We need to change the database encoding on our databases as they were created with the wrong encoding. They were created as

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Adrian Klaver
On Monday 24 January 2011 8:06:38 am Geoffrey Myers wrote: Adrian Klaver wrote: On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote: Adrian Klaver wrote: On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote: We need to change the database encoding on our databases as they were

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Geoffrey Myers
Adrian Klaver wrote: On Monday 24 January 2011 8:06:38 am Geoffrey Myers wrote: Adrian Klaver wrote: On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote: Adrian Klaver wrote: On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote: We need to change the database encoding on our

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Martijn van Oosterhout
On Mon, Jan 24, 2011 at 12:16:46PM -0500, Geoffrey Myers wrote: We hope to identify the characters and fix them in the existing database, then convert. It appears to be very limited, but it would help if there was some way to identify these characters outside of simply doing the reload

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Adrian Klaver
On 01/24/2011 09:16 AM, Geoffrey Myers wrote: We hope to identify the characters and fix them in the existing database, then convert. It appears to be very limited, but it would help if there was some way to identify these characters outside of simply doing the reload of the data and finding

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Geoffrey Myers
Adrian Klaver wrote: On 01/24/2011 09:16 AM, Geoffrey Myers wrote: We hope to identify the characters and fix them in the existing database, then convert. It appears to be very limited, but it would help if there was some way to identify these characters outside of simply doing the reload of

Re: [GENERAL] error while trying to change the database encoding on a database

2011-01-24 Thread Adrian Klaver
On 01/24/2011 10:57 AM, Geoffrey Myers wrote: Adrian Klaver wrote: On 01/24/2011 09:16 AM, Geoffrey Myers wrote: We hope to identify the characters and fix them in the existing database, then convert. It appears to be very limited, but it would help if there was some way to identify these