Re: Fixed length data types issue - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Fixed length data types issue
Date
Msg-id 45013DB9.4040505@dunslane.net
Whole thread Raw
In response to Re: Fixed length data types issue  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Fixed length data types issue  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers

Heikki Linnakangas wrote:
> Gregory Stark wrote:
>> But why would you use UTF8 to encode fixed length ascii strings?
>
> The encoding is set per-database. Even if you need UTF-8 to encode 
> user-supplied strings, there can still be many small ASCII fields in 
> the database. Country code, currency code etc.
>
>

ISTM we should revisit this when we get per-column encoding.

cheers

andrew


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Fixed length data types issue
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Fixed length data types issue