Horton

Re: JSON for PG 9.2

Simon Riggs <simon@2ndquadrant.com>

View thread
From: Simon Riggs <simon@2ndQuadrant.com>
To: Joey Adams <joeyadams3.14159@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-12-15T18:34:20Z
Lists: pgsql-hackers 
On Tue, Dec 13, 2011 at 8:15 AM, Joey Adams <joeyadams3.14159@gmail.com> wrote:

> Issues we've encountered include:
>
>  * Should JSON be stored as binary or as text?

Text

>  * How do we deal with Unicode escapes and characters if the server or
> client encoding is not UTF-8?  Some (common!) character encodings have
> code points that don't map to Unicode.  Also, the charset conversion
> modules do not provide fast entry points for converting individual
> characters; each conversion involves a funcapi call.

Make JSON datatypes only selectable if client encoding is UTF-8.

Lets JFDI

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services