It's only me?
Hugo, October 31, 2020 - 3:46 pm UTC
SQL*Plus: Release 19.0.0.0.0 - Production on Sáb Oct 31 12:42:30 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
SQL> select c, length(c), lengthb(c) from (
select substr(s, level, 1) c
from (
select 'àéíóúbcdef' s from dual
)
connect by level <= length(s)
)
where lengthb(c) > 1;
No rows selected
November 02, 2020 - 3:00 am UTC
What characterset is your database using?
It might be a single byte characterset that includes the characters you're using.
use select N'àéaíóúbcdef' s from dual;
bias, September 21, 2022 - 1:01 pm UTC
Use select N'àéaíóúbcdef' s from dual ;
ie, use data type as NVarchar2 that can store Unicode Chars