this But but but...
peter
edinburgh
-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Find an unprintable character inside a column
[EMAIL PROTECTED] wrote:
I played
: Find an unprintable character inside a column
Just a brief foot-note to this discussion.
The reason I selected the data, rather than attempted an automatic
correction, was that sometimes two words would be separated by ascii(10)
(forcing a line throw), and sometimes the corruption would appear
others then
return -1;
end BAD_ASCII;
/
--
-Original Message-
From: Prem Khanna J [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: Find an unprintable character inside
Some people have requested this code, so I thought
you might as well all
have the chance to pick it to bits... Its a
function called BAD_ASCII, and
it hunts out for any ascii characters with an ascii
value of less than 32 in
a specified field. (Acknowledgments to my colleague
Keith Holmes for help
character inside a column
Some people have requested this code, so I thought
you might as well all
have the chance to pick it to bits... Its a
function called BAD_ASCII, and
it hunts out for any ascii characters with an ascii
value of less than 32 in
a specified field. (Acknowledgments to my
character
inside a column
Some people have requested this code, so I thought
you might as well all
have the chance to pick it to bits... Its a
function called BAD_ASCII, and
it hunts out for any ascii characters with an ascii
value of less than 32 in
a specified field. (Acknowledgments
PROTECTED]
cc:
Subject:RE: RE: RE: Find an unprintable character inside a column
Actually, I was toying with the idea of writing an external
procedure that would allow me to call pcre library
(PCRE=Perl Compatible Regular Expressions) which would be nice,
but then again
/2003 07:09 AM cc:
Please respond to ORACLE-LSubject:RE: RE:
RE: Find an unprintable character
inside a column
Some people have requested this code, so I thought
you
DROP TABLE table_1;
CREATE TABLE table_1(data VARCHAR2(10));
INSERT INTO table_1 VALUES(CHR(1)||'ABC');
INSERT INTO table_1 VALUES('ABC'||CHR(25));
INSERT INTO table_1 VALUES(CHR(25)||'@'||CHR(30));
INSERT INTO table_1 VALUES(CHR(25)||'@'||CHR(31));
INSERT INTO table_1 VALUES('ABC');
COMMIT;
See notes, 113827.1, 119426.1, 154880.1. Could be done and done, but
not to solve this particular task -- it would be an overkill. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
[EMAIL PROTECTED] wrote:
: Find an unprintable character inside a column
[EMAIL PROTECTED] wrote:
I played with this a bit.
First, I created some test data with one column corrupted with a
single random character
of 0-31 replacing a random char in that column 20% of the rows of the
table.
Peter's function
Steve,
If you are patient, I guess that something like
where dump(problem_column) like '%target hex%'
should more or less answer your question.
HTH
SF
- --- Original Message --- -
From: Steve Main [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL
Yes, exactly Stephane -
Non-printable characters like this are a proper pest in our environment, to
the extent that I have exception reports running every night looking for
them (cannot trust the users...).
I have a small PL/SQL piece of code used to detect these things, if anyone
wants it.
Peter, i would be interested in that.
can u mail it to me ?
Jp.
09-10-2003 18:29:33, Robson, Peter [EMAIL PROTECTED] wrote:
I have a small PL/SQL piece of code used to detect these things, if anyone
wants it.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem
Peter, i would be interested in that.
can you mail it to me ?
Dias Costa
Robson, Peter wrote:
Yes, exactly Stephane -
Non-printable characters like this are a proper pest in our environment, to
the extent that I have exception reports running every night looking for
them (cannot trust the
Hello list,
I have an application that is choking on the following error,
...invalid character (Unicode: 0x19) was found in the element
content...
Does anyone know how I could go about searching for this invalid
character?
Thanks
Steve
--
Please see the official ORACLE-L FAQ:
16 matches
Mail list logo