> 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@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/