UTF8 encoding and non-text data types - Mailing list pgsql-sql

From Medi Montaseri
Subject UTF8 encoding and non-text data types
Date
Msg-id 8078a1730801121421l1c9b90c1lc65d36cf6e752a6f@mail.gmail.com
Whole thread Raw
List pgsql-sql
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 /> 

pgsql-sql by date:

Previous
From: Shane Ambler
Date:
Subject: Re: SQL question: Highest column value of unique column pairs
Next
From: Steve Midgley
Date:
Subject: Re: UTF8 encoding and non-text data types