Re: Proposal: Add JSON support

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposal: Add JSON support
Дата
Msg-id 19298.1269819370@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposal: Add JSON support  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Proposal: Add JSON support  (Robert Haas <robertmhaas@gmail.com>)
Re: Proposal: Add JSON support  (Mike Rylander <mrylander@gmail.com>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Here's another thought. Given that JSON is actually specified to consist 
> of a string of Unicode characters, what will we deliver to the client 
> where the client encoding is, say Latin1? Will it actually be a legal 
> JSON byte stream?

No, it won't.  We will *not* be sending anything but latin1 in such a
situation, and I really couldn't care less what the JSON spec says about
it.  Delivering wrongly-encoded data to a client is a good recipe for
all sorts of problems, since the client-side code is very unlikely to be
expecting that.  A datatype doesn't get to make up its own mind whether
to obey those rules.  Likewise, data on input had better match
client_encoding, because it's otherwise going to fail the encoding
checks long before a json datatype could have any say in the matter.

While I've not read the spec, I wonder exactly what "consist of a string
of Unicode characters" should actually be taken to mean.  Perhaps it
only means that all the characters must be members of the Unicode set,
not that the string can never be represented in any other encoding.
There's more than one Unicode encoding anyway...
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Proposal: Add JSON support
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Proposal: Add JSON support