Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M234158=pgsql-hackers-arkari@postgresql.org>)
 id 1VNAip-0006df-FN
 for pgsql-hackers@arkaria.postgresql.org; Sat, 21 Sep 2013 00:06:51 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M234158=pgsql-hackers-arkari@postgresql.org>)
 id 1VNAio-0003Xv-VJ
 for pgsql-hackers@arkaria.postgresql.org; Sat, 21 Sep 2013 00:06:51 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <maumau307@gmail.com>) id 1VNAYU-0001yB-8v
 for pgsql-hackers@postgresql.org; Fri, 20 Sep 2013 23:56:10 +0000
Received: from mail-pb0-x235.google.com ([2607:f8b0:400e:c01::235])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <maumau307@gmail.com>)
 id 1VNAYR-0005vW-Hm; Fri, 20 Sep 2013 23:56:09 +0000
Received: by mail-pb0-f53.google.com with SMTP id up15so961242pbc.26
 for <multiple recipients>; Fri, 20 Sep 2013 16:56:05 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:from:to:cc:references:in-reply-to:subject:date
 :mime-version:content-type:content-transfer-encoding;
 bh=9Kw6igC8+1lv2fz2J40jdFcTau8++j9fph+rMK8AFBQ=;
 b=R1/Ii0oit8OHxoBy1geifmRETv9vyN1TBJZ3Uf7m3Vc0LliH6gPNln6H3abIxhfZw+
 hiRe/spiVYjkidzZ26YqDUiiWL/7IpTGd6oMObe/YDa1b/4KoVqMARygzmVCCzYZuw2f
 7m29dRG665hdqO3m2M4PpXrm3bdh27sRUV/IgqBjrpe2GZtidENtQP+jOk8ntq3z18r2
 N/rJcj1kIq4d2gbEMxV6gfdZ2XiKeyBwmg2J/UhZtJ143RSn5NGnEdyXMPDkvTQqgOc5
 fcCRy26G/tSUJlJ6UBF/5ESvoZiWeZA9govGPyw2sMbbV+deZk97WFTDGVllpSnG77XH
 Hxww==
X-Received: by 10.68.244.200 with SMTP id xi8mr10598225pbc.156.1379721365565;
 Fri, 20 Sep 2013 16:56:05 -0700 (PDT)
Received: from maumau (p6019-ipbfp211sizuokaden.shizuoka.ocn.ne.jp.
 [114.170.213.19])
 by mx.google.com with ESMTPSA id f2sm18215275pbg.44.1969.12.31.16.00.00
 (version=TLSv1 cipher=RC4-SHA bits=128/128);
 Fri, 20 Sep 2013 16:56:04 -0700 (PDT)
Message-ID: <25023FC76F8940619C3780B99E733D24@maumau>
From: "MauMau" <maumau307@gmail.com>
To: "Martijn van Oosterhout" <kleptog@svana.org>,
 "Tatsuo Ishii" <ishii@postgresql.org>
Cc: <robertmhaas@gmail.com>, <tgl@sss.pgh.pa.us>,
 <maksymb@fast.au.fujitsu.com>, <hlinnakangas@vmware.com>,
 <pgsql-hackers@postgresql.org>
References: <904.1378304922@sss.pgh.pa.us>
 <B1A7485194DE4FDAB8FA781AFB570079@maumau>
 <CA+TgmobWv_96dSfSHv2ZJWSXAD=QTiBEKw-LT359sGArYe+AXQ@mail.gmail.com>
 <20130920.085853.1628917054830864151.t-ishii@sraoss.co.jp>
 <20130920101039.GA32048@svana.org>
In-Reply-To: <20130920101039.GA32048@svana.org>
Subject: Re: UTF8 national character data type support WIP patch and list of
 open issues.
Date: Sat, 21 Sep 2013 08:58:15 +0900
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
 reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
X-Pg-Spam-Score: 0.6 (/)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

From: "Martijn van Oosterhout" <kleptog@svana.org>
> As far as I can tell the whole reason for introducing NCHAR is to
> support SHIFT-JIS, there hasn't been call for any other encodings, that
> I can remember anyway.

Could you elaborate on this, giving some info sources?


> So rather than this whole NCHAR thing, why not just add a type
> "sjistext", and a few type casts and call it a day...

The main reason for supporting NCHAR types is to ease migration from other 
DBMSs, not requiring DDL changes.  So sjistext does not match that purpose.


Regards
MauMau



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers