Re: Problem with encoding - Mailing list pgsql-general

From John R Pierce
Subject Re: Problem with encoding
Date
Msg-id 4DB5BB30.7050108@hogranch.com
Whole thread Raw
In response to Problem with encoding  (SUBHAM ROY <subham.iem@gmail.com>)
List pgsql-general
On 04/25/11 11:14 AM, SUBHAM ROY wrote:
> While loading data from shape files, the default encoding type is
> UTF8. It reports an error "couldn't convert to UTF8 ... change the
> encoding to latin1 ... etc."
>

what reported this?

> So my question is, if one table say T1 is loaded using UTF8 and the
> other say T2 is loaded using say LATIN1, then does it impose any
> problem while querying, i.e. while running queries.

different client_encoding, or server encoding?  you can't mix server
encodings, but the client could in theory switch client_encoding back
and forth as it executes various queries, that would be a pain in the butt.



pgsql-general by date:

Previous
From: SUBHAM ROY
Date:
Subject: Problem with encoding
Next
From: Phoenix Kiula
Date:
Subject: Re: Help - corruption issue?