Re: [JDBC] JDBC Driver Munging My Text?

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Hunter Hillegas" <lists(at)lastonepicked(dot)com>, "PostgreSQL" <pgsql-general(at)postgresql(dot)org>, "Postgre JDBC" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] JDBC Driver Munging My Text?
Date: 2001-12-20 17:18:13
Message-ID: NEBBLAAHGLEEPCGOBHDGMEKBEBAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

> Basically what we are seeing is that text stored in a VARCHAR is entered
> like this: "hello, how are you" is stored like this: "hello ,how are you".
> Notice the space and comma being transposed...

No ideas to fix it, but I can add the info that it has never happened to me
using the jdbc7.1-1.1.jar or jdbc7.1-1.2.jar driver files. We have one
field, "full name" in our db that is of the format "Smith, Joe", so I think
I'd have experienced the problem if it exists in our system. (Debian 2.4,
PGSQL 7.1.3, IBM Java 2 compiler & vm)

I'd suggest downloading one of the precompiled jar files & dropping them
into your misbehaving new server, just to eliminate any possibility that the
build is involved (though I can't see how it could be...) The precompiled
drivers live at: http://jdbc.postgresql.org/download.html

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2001-12-20 17:29:28 Creation date
Previous Message Hunter Hillegas 2001-12-20 16:44:32 JDBC Driver Munging My Text?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter T. Brown 2001-12-20 17:27:08 Re: controlling process priority
Previous Message Hunter Hillegas 2001-12-20 16:44:32 JDBC Driver Munging My Text?