From: Medi Montaseri <montaseri@gmail.com>
To: pgsql-sql@postgresql.org
Subject: UTF8 encoding and non-text data types
Date: Sat, 12 Jan 2008 14:21:00 -0800
Message-ID: <8078a1730801121421l1c9b90c1lc65d36cf6e752a6f@mail.gmail.com> (raw)
I understand PG supports UTF-8 encoding and I have sucessfully inserted
Unicode text into columns. I was wondering about other data types such as
numbers, decimal, dates
That is, say I have a table t1 with
create table t1 { name text, cost decimal }
I can insert UTF8 text datatype into this table with no problem
But if my application attempts to insert numbers encloded in UTF8, then I
get wrong datatype error
Is the solution for the application layer (not database) to convert the
non-text UTF8 numbers to ASCII and then insert it into database ?
Thanks
Medi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: montaseri@gmail.com
Subject: Re: UTF8 encoding and non-text data types
In-Reply-To: <8078a1730801121421l1c9b90c1lc65d36cf6e752a6f@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox