Hi Mark,

There are two ways.

In terminal monitor preceed the control character with a CTRL-V. The
CTRL-V will not echo.

ie to enter a CTRL-M type ... <CTRL-V><CTRL-M>
create table x(a varchar(20))\g
insert into x values('asdf')\g
insert into x values('asdf^Mduck')\g
select * from x\g
lqqqqqqqqqqqqqqqqqqqqk
xa                   x
tqqqqqqqqqqqqqqqqqqqqu
xasdf                x
xasdf\rduck          x
mqqqqqqqqqqqqqqqqqqqqj

The alternative is to enter a specific hex character like so...
insert into x values('tom' + X'0a' + 'dick')\g

The select would now also show: tom\ndick

Martin Bowes

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Mark
Sent: 28 August 2008 09:56
To: info-ingres@kettleriverconsulting.com
Subject: [Info-Ingres] How to insert control characters into varchar
column

Hi,

I need to reproduce a problem that is occurring in a database.  I
think that stray control characters are being added to a varchar
column.

Can anyone tell me how to insert control characters using terminal
monitor or qbf so I can test my theory?

TIA.