Hi,
I need your help.
I am doing a search with ALTER SESSION SET NLS_SORT="GENERIC_BASELETTER";
This works fine with accent letters but also we need that works also with german letter "ß".
select * from table1 where name like '%ss%';
0 rows found.
select * from table1 where upper(name) like '%SS%';
0 rows found.
I've try with this other type of sentence but it doesn't exist in TimesTen:
SELECT * table1 where UPPER(name, 'NLS_SORT = XGERMAN') like '%SS%'
Are there any possibility that works in both needs with the same NLS_SORT ??
Or it could be possible that we do a change and the search works also for letter "ß" ??
I work with TimesTen Release 11.2.2.4.0 (64 bit Solaris/x86)
Thanks in advance.
Babs.