find Extended ASCII Codes or Character Special on column oracle
Hi everyone, i'll want to use query for to find all character special and extended ASCII codes on column
i have tried this records:
select * from char_speciale
---------------------------
SURNAME NAME
SERPI!! GAB
SE£ GRA
ARA%%& sa
@dass dsadsa
ara€ ssa
gabriele dsa
-------------------------------------------------------------------------------------------------------------
select * from char_speciale
where regexp_like(surname, '('|| chr(33) || '|'
|| chr(37) || ')')
---------------------------------
SURNAME NAME
SERPI!! GAB
ARA%%& sa
-------------------------------------------------------------------------------------------------------------
select * from char_speciale
where regexp_like(surname,'[[:punct:]]');
--------------------------------
SURNAME NAME
SERPI!! GAB
SE£ GRA
ARA%%& sa
@dass dsadsa
ara€ ssa
-------------------------------------------------------------------------------------------------------------
select * from char_speciale WHERE surname != ASCIISTR (surname)
----------------------------
SURNAME NAME
ara€ ssa
SE£ GRA
-------------------------------------------------------------------------------------------------------------
but i don't see just query, because i'll want to find also extended ascii, for example german "o" or french "e", ecc.
on my table use NLS_CHARACTERSET: AL32UTF8
i don't know that i have insert just query but i'm not sure.... do have better solution? thank much