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