I understand PG supports UTF-8 encoding and I have sucessfully inserted Unicode text into columns. I was wondering
aboutother data types such as numbers, decimal, dates<br /><br />That is, say I have a table t1 with<br />create table
t1{ name text, cost decimal } <br />I can insert UTF8 text datatype into this table with no problem<br />But if my
applicationattempts to insert numbers encloded in UTF8, then I get wrong datatype error<br /><br />Is the solution for
theapplication layer (not database) to convert the non-text UTF8 numbers to ASCII and then insert it into database ?
<br/><br />Thanks<br />Medi<br />