×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Since I just subscribed I can't reply directly in the right thread, but
hopefully this will do. I happen to have an SQL session open and a
REGEXP_INSTR test jig left over from my own question, so I thought I'd do a
little test.
It seems despite the manual page strongly implying that the hex should be
lower-case, it only works if it's upper-case, viz:
with foo(bar) as (
values('--- CONN '))
SELECT foo.bar, hex(foo.bar),
regexp_instr(foo.bar,'[\X00-\X3F]')
FROM
foo
WHERE
regexp_instr(foo.bar,'[\X00-\X3F]') > 0
--
Arnie
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
