From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Medi Montaseri" <montaseri(at)gmail(dot)com> |
Cc: | "Steve Midgley" <public(at)misuse(dot)org>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: UTF8 encoding and non-text data types |
Date: | 2008-01-14 19:22:52 |
Message-ID: | 23645.1200338572@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
"Medi Montaseri" <montaseri(at)gmail(dot)com> writes:
> More specifically, I am using HTML, Perl and PG. So from the HTML point of
> view a textfield is just some strings. So my user would enter 12345 but
> expressed in UTF8. Perl would get this and use DBI to insert it into PG
> What I am experiencing now is that DB errors that I am trying to insert an
> incorrect data into column "cost" which is numeric and the data is coming in
> from HTML in UTF8
> Mybe I have to convert it to ASCII numbers in Perl before inserting them
> into PG
Uh, there is *no* difference between the ASCII and UTF8 representations
of decimal digits, nor of any other character that would be allowed in
input for a decimal field. I can't tell what your problem really is,
but you have certainly misunderstood or misexplained it.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | dmp | 2008-01-14 19:51:57 | Re: UTF8 encoding and non-text data types |
Previous Message | Medi Montaseri | 2008-01-14 19:01:36 | Re: UTF8 encoding and non-text data types |