Re: Why do we let CREATE DATABASE reassign encoding? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Why do we let CREATE DATABASE reassign encoding?
Date
Msg-id 49F0C109.8010109@dunslane.net
Whole thread Raw
In response to Re: Why do we let CREATE DATABASE reassign encoding?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:
> If we wanted to be entirely anal about this, we could allow SQL_ASCII
> destination with a different source encoding, but not the reverse.
> However, we currently consider that you're on your own to ensure sanity
> when using SQL_ASCII as far as locale goes, so I'm not sure why the
> policy would be different for encoding.
>
>             
>   

The trouble is that people won't know the provenance of their database. 
I think we should try to guarantee as far as possible that if a database 
has encoding X then all the data in it is valid in that encoding.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why do we let CREATE DATABASE reassign encoding?
Next
From: "David E. Wheeler"
Date:
Subject: Re: Why do we let CREATE DATABASE reassign encoding?