Re: Bug extracting money value - Mailing list pgsql-jdbc

From Markus Schaber
Subject Re: Bug extracting money value
Date
Msg-id 4520B9DF.1030901@logix-tt.com
Whole thread Raw
In response to Re: Bug extracting money value  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Bug extracting money value  (Markus Schaber <schabi@logix-tt.com>)
List 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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Bug extracting bit value
Next
From: Markus Schaber
Date:
Subject: Re: Bug extracting money value