Tom Lane wrote:
"Medi Montaseri" <[EMAIL PROTECTED]> writes:
insert into t1 (c1, cost) values ('tewt', 1234)
this works find....
insert into t1 (c1, cost) values ('شد',
۱۲۳۴)
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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
