Re: Fixed length data types issue

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: mark(at)mark(dot)mielke(dot)cc
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Gregory Stark <gsstark(at)mit(dot)edu>, andrew(at)supernews(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fixed length data types issue
Date: 2006-09-08 20:49:22
Message-ID: 4501D752.8090208@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

mark(at)mark(dot)mielke(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2006-09-08 20:49:49 Re: Fixed length data types issue
Previous Message Gevik Babakhani 2006-09-08 20:46:39 Re: Proposal for GUID datatype