Newline inserted via sqlworksheet

From: Baylis, John <JBaylis_at_mail.canfor.ca>
Date: Tue, 31 Oct 2000 11:16:31 -0800
Message-Id: <10666.120712@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0436F.139708B0
Content-Type: text/plain

Oracle 8.0.5 on NT

I have a table with a column defined as a varchar2(4000) I can insert any string of 215 characters into the column without any problems using sqlplus or sqlworksheet.
If I insert a string of 216 characters with no spaces in the text, it works fine in sqlworksheet.
If I insert a string of 216 characters with spaces in the text, it works fine using sqlplus
but when I use Sqlworksheet, it inserts a Newline character where the space is.
For some reason, the column is wrapping to the next line where that Newline character is inserted.

Where does Sqlworksheet get this line wrapping value from? I want the column to contain the text as entered, not to insert Linefeed (x'10) values.
My sqlplus glogin.sql has a linesize of 500. How can I override this linesize problem in sqlworksheet? Any ideas?

John Baylis
DBA / Systems Administrator
Canadian Forest Products Ltd.
Vancouver B.C. Canada

------_=_NextPart_001_01C0436F.139708B0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>Newline inserted via sqlworksheet</TITLE>
</HEAD>
<BODY>

Oracle 8.0.5 on =
NT


I have a table with =
a column defined as a varchar2(4000) 
 I can insert any =
string of 215 characters into the column without any problems using = sqlplus or sqlworksheet.
 If I insert a =
string of 216 characters with no spaces in the text, it works fine in = sqlworksheet.
 If I insert a =
string of 216 characters with spaces in the text, it works fine using = sqlplus
 but when I use =
Sqlworksheet, it inserts a Newline character where the space is.
 For some reason, =
the column is wrapping to the next line where that Newline character is = inserted.


Where does =
Sqlworksheet get this line wrapping value from?
 I want the column =
to contain the text as entered, not to insert Linefeed (x'10) = values.
 My sqlplus =
glogin.sql has a linesize of 500.
 How can I override =
this linesize problem in sqlworksheet?
 Any ideas?


John =
Baylis
 DBA / Systems Administrator
 Canadian Forest Products Ltd.
 Vancouver B.C. Canada
Received on Tue Oct 31 2000 - 13:16:31 CST