Re: UTF8 national character data type support WIP patch and list of open issues. - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: UTF8 national character data type support WIP patch and list of open issues.
Date
Msg-id 1380077397.1440.25.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: UTF8 national character data type support WIP patch and list of open issues.  ("MauMau" <maumau307@gmail.com>)
Responses Re: UTF8 national character data type support WIP patch and list of open issues.
List pgsql-hackers
On Tue, 2013-09-24 at 21:04 +0900, MauMau wrote:
> "4. I guess some users really want to continue to use ShiftJIS or EUC_JP for
> database encoding, and use NCHAR for a limited set of columns to store
> international text in Unicode:
> - to avoid code conversion between the server and the client for performance
> - because ShiftJIS and EUC_JP require less amount of storage (2 bytes for
> most Kanji) than UTF-8 (3 bytes)
> This use case is described in chapter 6 of "Oracle Database Globalization
> Support Guide"."

But your proposal wouldn't address the first point, because data would
have to go client -> server -> NCHAR.

The second point is valid, but it's going to be an awful amount of work
for that limited result.




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ENABLE/DISABLE CONSTRAINT NAME
Next
From: Amit Kapila
Date:
Subject: Re: dynamic shared memory