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

Re: [JDBC] JDBC Driver Munging My Text?

From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
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:52:08
Message-ID: 002901c1897f$0b2301a0$c201a8c0@inspiron (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-jdbc

Can you provide the insert statement that inserts this


-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Hunter Hillegas
Sent: Thursday, December 20, 2001 11:45 AM
To: PostgreSQL; Postgre JDBC
Subject: [JDBC] JDBC Driver Munging My Text?

We are seeing some strange behavior in our system that uses Postgres
7.1.3 and JDBC. System: Red Hat Linux 7.1/Intel.

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...

The plot thickens...

This is on a new server. The old server, also running 7.1.3, though
built quite a long time ago, does not exhibit this behavior.

Any ideas? Known bug? Strange config? It is possible that I built the
JDBC driver on the old machine and just copied it to the new machine...
I can't remember but it shouldn't matter, should it?


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

In response to

pgsql-jdbc by date

Next:From: Chantal AckermannDate: 2001-12-20 18:11:47
Subject: The new driver and PostgreSQL7.1.3
Previous:From: Peter T. BrownDate: 2001-12-20 17:27:08
Subject: Re: controlling process priority

pgsql-general by date

Next:From: David LinkDate: 2001-12-20 19:48:22
Subject: Re: sql scripts
Previous:From: Johnson, ShaunnDate: 2001-12-20 17:29:28
Subject: Creation date

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