From: Jens Carlberg <jenca@lysator.liu.se>
To: pgsql-interfaces@postgresql.org
Subject: Re: Newlines in String inserts with JDBC
Date: Thu, 28 Sep 2000 11:21:03 +0200
Message-ID: <39D30D7F.3259B35@lysator.liu.se> (raw)
References: <39D28E41.B22FFB7C@toad.net>
Ken Kachnowich wrote:
>
> Is there a method that could be used to insert Strings containing
> newline charaters using the JDBC interface?
I haven't tried this, but allow me to speculate:
1. If new-line isn't allowed as a char, it can't be done at all. Then
you have to invent a mapping on your own. I would recommend "\n"; it's
failrly standard. Note that this means you have to escape "\" too; I
recommend "\\".
2. However, if new-line is allowed (and I suspect it is), it should
probably be 'escaped' somehow. This might be database specific; your
Java-code shouldn't be, though. To solve this, use the PreparedStatement
class, and simply set the String:
String aString = "Row 1: Before newline\nRow 2: After newline";
PreparedStatement aStmt = aConn.prepareStatement();
aStmt.setString(aString);
This way, you delegate to the classes developed for this specific
database to handle all issues specific to the database, as it should be.
> Ken
///Jens Carlberg
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jenca@lysator.liu.se
Subject: Re: Newlines in String inserts with JDBC
In-Reply-To: <39D30D7F.3259B35@lysator.liu.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox