Re: [UNCLASSIFIED] - RE: Determining which rows have characters outside of the standard ASCII (0-127)

From: Ilmar Kerm <ilmar.kerm@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 9 Nov 2010 17:30:47 +0200

On Tue, Nov 9, 2010 at 4:39 PM, Ian Cary <ian.cary@xxxxxxxxxxxxxx> wrote:
> Hi Mark,
>
> Would regexp_instr(doc_authors,'[[:alnum:][:blank:][:cntrl:][:punct:]]')
> help as I believe this covers ascii(0-127)

[:alnum:] also covers non-7bit alphabet letters, so this shouldn't
work in the current case.
And this does not seem to be affected by NLS_LANGUAGE setting. From 11.2.0.2:

SQL> alter session set nls_language='estonian';

Session altered.

SQL> select 1 from dual where regexp_instr('õ', '[[:alnum:]]') > 0;

         1
----------
         1

SQL> alter session set nls_language='american';

Session altered.

SQL> select 1 from dual where regexp_instr('õ', '[[:alnum:]]') > 0;

         1
----------
         1


-- 
Ilmar Kerm
--
http://www.freelists.org/webpage/oracle-l

References:

[UNCLASSIFIED] - RE: Determining which rows have characters outside of the standard ASCII (0-127)
From: Ian Cary

Re: [UNCLASSIFIED] - RE: Determining which rows have characters outside of the standard ASCII (0-127)

Other related posts: