Hello,
Does anyone have an example of how to insert raw ascii into a varchar2 field?
For example,
CREATE TABLE LH_test
( col1 varchar2(10),
col2 varchar2(10),
col3 varchar2(10) )
PCTFREE 0 PCTUSED 80 INITRANS 1 MAXTRANS 255 LOGGING
STORAGE(INITIAL 5M NEXT 5M MINEXTENTS 1
MAXEXTENTS 2147483645 PCTINCREASE 0
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE REGDAT ;
commit ;
insert into lh_test values ( 'X'||chr(9), 'Y'||chr(A), 'Z'||chr(D) ) ;
Why am I doing this? Because some non-printable ascii codes have been inserted in some fields and I am tasked with finding the bad data. I need a test bed to insure I can scan for ranges of ascii characters, and need a range of known ascii printable and non-printable characters in a test table.
The bad data can be in over 200 fields, so I need a broad tool; I'll gen the select statements after I have some test data to work with.
Any suggestions or referrals are appreciated.
Regards,
Linda
