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 JANUARY 25, 2016

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 to 9.3.4.0 [Release 9.3]
Information in this document applies to any platform.

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 : 部品情報(multibyte characters)
3. Open Advanced Search
    Item: :Object Search
    Description Like '部品*'  -> no result
    Description Like '部品??' -> P00001 is found
    Description Like '*情報'  -> P00001 is found
    Description Like '??情報' -> 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms