Lazy Loading & Diacritics

[vincentmorneau]

Default behavior is to ignore diacritics, which is good. When using Lazy Loading we can't control diacritics.

Without Lazy Loading: https://demo.insum.ca/ords/f?p=131:1
With Lazy Loading: https://demo.insum.ca/ords/f?p=131:2

Both examples, you can use Country Canada and Province Québec.

[nbuytaert1]

The Select2 library takes care of the diacritics search. I didn't support this search algorithm in the PL/SQL code though. When using Lazy Loading, the filtering happens in PL/SQL, thus with diacritics.

Do you know a way to convert all "special" characters to "normal" characters in PL/SQL?

[vincentmorneau]

Two options comes to mind:

1. select convert('Québec', 'US7ASCII') diacritics from dual;
2. select utl_raw.cast_to_varchar2(nlssort('Québec', 'nls_sort=binary_ai')) diacritics from dual;