Re: UTF8 encoding and non-text data types

Tom Lane wrote:
> "Medi Montaseri" <montaseri(at)gmail(dot)com> writes:
>
>> insert into t1 (c1, cost) values ('tewt', 1234)
>> this works find....
>> insert into t1 (c1, cost) values ('&#1588;&#1583;',
>> &#1777;&#1778;&#1779;&#1780;)
>> DBD::Pg::db do failed: ERROR: syntax error at or near ";" at character 59,
>>
>
> 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.

Joe