displaying control characters in sqlplus

From: Al Bell <bella_at_navcanada.ca>
Date: 18 Apr 2002 07:16:55 -0700
Message-ID: <c683fefd.0204180616.1679b1b6@posting.google.com>

If a table contains an entry which includes a control character, the screen output from select statement in sqlplus V8 for Windows gives a representation of the control character. A good example is backspace character (chr(8)).

When sqlplus under Oracle 7.3.4 on HP-UX is used to view table with any type of X terminal (hpterm, dtterm, xterm), the control character is translated rather than displayed. For example, 'abc' || chr(8) || '12' displays as ab12.

Is there a way to emulate the Windows behaviour on the Unix side? I have tried using different TERM variable settings and a couple of stty changes to no avail.

Alvin Bell
Support Specialist
Nav Canada Received on Thu Apr 18 2002 - 09:16:55 CDT