I've just copied the test script again and run it from scratch
I get one difference as I switch from german_ai to binary_ai, and that's
with:
select * from t_object where name like '\_%' escape '\';
German_ai -->
NAME
------------
\A
1 row selected.
binary_ai -->
NAME
------------
_A
_??
_B
_
4 rows selected.
The ?? is presumably because my terminal setting doesn't allow the Ä to
travel from client to server.
For reference these are my server character settings.
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
Regards
Jonathan Lewis
On Wed, 3 Mar 2021 at 18:44, Martin Berger <martin.a.berger@xxxxxxxxx>
wrote:
alter session set nls_sort=binary_ai ;
does not change anything.
If I get substantial updates from Oracle I'll post it here.
regards,
Martin