FW: JDBC Driver Munging My Text?

Forgot to add the list...

------ Forwarded Message
From: Hunter Hillegas <lists(at)lastonepicked(dot)com>
Date: Thu, 20 Dec 2001 09:54:41 -0800
To: <Dave(at)micro-automation(dot)net>
Subject: Re: [JDBC] JDBC Driver Munging My Text?

Sure...

The Java code is like this:

pst = con.prepareStatement("insert into news (rec_num, title, body, lead_in,
location, source, display_order, date_of_entry, entered_by, active_status)
values (nextval('news_seq'), ?, ?, ?, ?, ?, ?, ?, ?, ?)");

The news table looks like this:

CREATE TABLE news (
rec_num integer NOT NULL PRIMARY KEY,
title varchar(255),
body text,
lead_in text,
location varchar(255),
source varchar(255),
display_order integer,
date_of_entry date,
entered_by integer REFERENCES users,
active_status boolean
);

> From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
> Organization: Micro Automation Inc
> Reply-To: <Dave(at)micro-automation(dot)net>
> Date: Thu, 20 Dec 2001 12:52:08 -0500
> 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?
>
> Hunter,
>
> Can you provide the insert statement that inserts this
>
> Dave
>
> -----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?
>
> Thanks,
> Hunter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

------ End of Forwarded Message