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

From Andrew Dunstan
Subject Re: Fixed length data types issue
Date
Msg-id 4501D752.8090208@dunslane.net
Whole thread Raw
In response to Re: Fixed length data types issue  (mark@mark.mielke.cc)
Responses Re: Fixed length data types issue  (mark@mark.mielke.cc)
List pgsql-hackers
mark@mark.mielke.cc wrote:
> Only ASCII values store more space efficiently in UTF-8. All values
> over 127 store more space efficiently using UTF-16. 
>
>   

This second statement is demonstrably not true. Only values above 0x07ff 
require more than 2 bytes in UTF-8. All chars up to that point are 
stored in UTF-8 with greater or equal efficiency than that of UTF-16.  
See http://www.zvon.org/tmRFC/RFC2279/Output/chapter2.html

cheers

andrew


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Fixed length data types issue
Next
From: "Guillaume Smet"
Date:
Subject: Re: log_duration is redundant, no?