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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-jdbc by date

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

pgsql-general by date

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

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