Re: What's a correct or good Encoding for Postgres 9.1.2?

Hi

We were getting this error.

ERROR: invalid byte sequence for encoding "UTF8": 0xa0

We are thinking of using SQL_ASCII in postgres 9.1.2

And that we will be feeding from backup server(UTF-8) into another server that’s using SQL_ASCII. Where are not if it’ll be fine to feed from UTF-8 to SQL_ASCII.

Clear explaination:

We have

Primary server and the backup server running on postgres7.3.4 using SQL_ASCII. And another server which is already on 9.1.2 already is using SQL_ASCII. We feed the same data(from backup server) into this third server.

Now we are upgrading these two servers(primary and backup) to Postgres9.1.2 where we use UTF-8 encoding.

So talking about compatibility, you are saying we can continue using UTF-8?, but this will create more work for us because most of our scripts assume that encoding is  SQL_ASCII hence we want continue using SQL_ASCII in Postgres 9.1.2.

Thanks

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of gelin yan
Sent: Wednesday, May 30, 2012 6:59 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] What's a correct or good Encoding for Postgres 9.1.2?

CONFIDENTIALITY NOTICE

The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited.

If you are not the intended addressee please notify the writer immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.