In Advanced Search, Wildcard Search With Asterisk Added to the End of the Multibyte Characters Does Not Work (Doc ID 2021826.1)

Last updated on JUNE 19, 2019

Applies to:

Symptoms

Actual Behavior
In advanced search, wildcard search with asterisk added to the end of the multibyte characters does not work

Expected Behavior
In advanced search, wildcard search with asterisk added to the end of the multibyte characters works correctly

Steps
1. Login to Web Client
2. Create a part:P00001 with description : Parts information(multibyte characters)
3. Open Advanced Search
    Item: :Object Search
    Description Like 'parts*'  -> no result
    Description Like 'parts??' -> P00001 is found
    Description Like '*information'  -> P00001 is found
    Description Like '??information' -> P00001 is found


What Is Working
The wildcard search with asterisk added to the end of the single byte characters (English) works correctly
If using the percent '%' as wildcard character instead of the asterisk '*', the search works correctly

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.