From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joe <dev@freedomcircle.net>
Cc: Medi Montaseri <montaseri@gmail.com>
Cc: Steve Midgley <public@misuse.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: UTF8 encoding and non-text data types
Date: Mon, 14 Jan 2008 18:24:33 -0500
Message-ID: <8278.1200353073@sss.pgh.pa.us> (raw)
In-Reply-To: <478BEA35.1010405@freedomcircle.net>
References: <20080113222706.73BE416DA2AB@mx1.hub.org>
<478aea79.03098c0a.5f32.ffffa6e4SMTPIN_ADDED@mx.google.com>
<8078a1730801141101j4bc0dc4chdffee5eaebdb99da@mail.gmail.com>
<20080114201831.B34BA2E2CC4@postgresql.org>
<8078a1730801141243o63676d02mdb1e3a539679f79f@mail.gmail.com>
<7578.1200350483@sss.pgh.pa.us>
<478BEA35.1010405@freedomcircle.net>
Joe <dev@freedomcircle.net> writes:
> Tom Lane wrote:
>> Well, you've got two problems there. The first and biggest is that
>> &#NNN; is an HTML notation, not a SQL notation; no SQL database is going
>> to think that that string in its input is a representation of a single
>> Unicode character. The other problem is that even if this did happen,
>> code points 1777 and nearby are not digits; they're something or other
>> in Arabic, apparently.
>>
> Precisely. 1777 through 1780 decimal equate to code points U+06F1
> through U+06F4, which correspond to the Arabic numerals 1 through 4.
Oh? Interesting. But even if we wanted to teach Postgres about that,
wouldn't there be a pretty strong risk of getting confused by Arabic's
right-to-left writing direction? Wouldn't be real helpful if the entry
came out as 4321 when the user wanted 1234. Definitely seems like
something that had better be left to the application side, where there's
more context about what the string means.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, dev@freedomcircle.net, montaseri@gmail.com, public@misuse.org
Subject: Re: UTF8 encoding and non-text data types
In-Reply-To: <8278.1200353073@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox