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.
--
(\__/) M.
(='.'=) Owing to the amount of spam posted via googlegroups and
(")_(") their inaction to the problem. I am blocking most articles
posted from there. If you wish your postings to be seen by
everyone you will need use a different method of posting.
See http://improve-usenet.org

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.RemoveThis@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Mark
Sent: 28 August 2008 09:56
To: info-ingres.RemoveThis@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.
--
(\__/) M.
(='.'=) Owing to the amount of spam posted via googlegroups and
(")_(") their inaction to the problem. I am blocking most articles
posted from there. If you wish your postings to be seen by
everyone you will need use a different method of posting.
See http://improve-usenet.org

_______________________________________________
Info-Ingres mailing list
Info-Ingres.RemoveThis@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres