BUG #3935: about Unicode values

Lists: pgsql-bugs
From: "Vaibhav More" <vaibhav(dot)more2008(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3935: about Unicode values
Date: 2008-02-06 06:11:24
Message-ID: 200802060611.m166BOan079876@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3935
Logged by: Vaibhav More
Email address: vaibhav(dot)more2008(at)gmail(dot)com
PostgreSQL version: 1.6.2
Operating system: Windows XP
Description: about Unicode values
Details:

I have problem in displaying Unicode(utf-8) integer values in my query.
insert in table values('','');
here is an int value.


From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Vaibhav More <vaibhav(dot)more2008(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3935: about Unicode values
Date: 2008-02-06 09:16:14
Message-ID: 20080206091614.GA73547@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On Wed, Feb 06, 2008 at 06:11:24AM +0000, Vaibhav More wrote:
> PostgreSQL version: 1.6.2

This looks like a pgAdmin version, not a PostgreSQL version. What
does "SELECT version()" return?

> I have problem in displaying Unicode(utf-8) integer values in my query.
> insert in table values('२६','वैभव');
> here २६ is an int value.

Could you expand on what problem you're having? What exactly are
you doing, what are you expecting to happen, and what actually does
happen?

Your int value appears to be 26 in Devanagari. Are you trying to
store that value in an integer column? I don't think PostgreSQL
supports numbers in non-Latin scripts unless your underlying strtol()
and sprintf() functions do.

--
Michael Fuhr