Re: json accessors - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: json accessors
Date
Msg-id 50B8E02F.5090509@dunslane.net
Whole thread Raw
In response to Re: json accessors  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-hackers
On 11/30/2012 10:59 AM, Hannu Krosing wrote:
>
> Btw, how does current json type handle code pages - is json always 
> utf-8 even when server encoding is not ?
>
> if so then we could at least have a shortcut conversion of json to 
> utf8-text which can skip codepage changes.
>
>

IIRC json is stored and processed in the server encoding. Normally it 
would make sense to have that be utf8. It is delivered to the client in 
the client encoding.

cheers

andrew




pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [PATCH] Patch to fix a crash of psql
Next
From: Tatsuo Ishii
Date:
Subject: Re: [PATCH] Patch to fix a crash of psql