Skip site navigation (1) Skip section navigation (2)

Re: Bug extracting money value

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: Holger Schulz <hst1(at)online(dot)de>
Subject: Re: Bug extracting money value
Date: 2006-10-02 07:03:59
Message-ID: 4520B9DF.1030901@logix-tt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi, Oliver,

Oliver Jowett wrote:

>> I always get an exception when I try to extract the money value I
>> inserted this way:
> 
> "money" isn't a well-supported type on the server side (I believe its
> use is no longer recommended) .. IIRC the formatting rules for it are
> locale-specific, among other problems.

Without having looked at the code, I think that the ? in getString()
comes from the backend formatting the Value with an EUR symbol, and the
JDBC driver looking for a $ to skip.

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org

In response to

Responses

pgsql-jdbc by date

Next:From: Markus SchaberDate: 2006-10-02 07:36:21
Subject: Re: Bug extracting money value
Previous:From: Oliver JowettDate: 2006-10-01 21:25:29
Subject: Re: Bug extracting bit value

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group