Message-ID: <39D3C138.86C1FDDB@toad.net>
Date: Thu, 28 Sep 2000 18:07:52 -0400
From: Ken Kachnowich <khkachn@toad.net>
Reply-To: khkachn@NOSPAMtoad.net
MIME-Version: 1.0
To: Postgres interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: Newlines in String inserts with JDBC
References: <39D28E41.B22FFB7C@toad.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Sorry, I did not give enough information.
I am using the Serialize class. It builds an SQL insert statement in 
a String and the back end seems to fail if there is a newline in 
a text fields value.
If the PreparedStatement and setString work with newlines then I can
look into using that. I need to get a resultSet back, though, so I can
figure out what the record OID is of the record I just inserted.

Ken

Ken Kachnowich wrote:
> 
> Is there a method that could be used to insert Strings containing
> newline charaters using the JDBC interface? I could replace them
> with some character before the insert but what would be a good
> character to use?
> 
> Thanks,
> 
> Ken