SQL LIKE pattern matching broken for non-ASCII/multibyte characters

[qianheng-aws]

Issue

LIKE queries don't work correctly with multibyte characters (Chinese, Japanese, Korean, etc).

Example:

SELECT * FROM products WHERE description LIKE '%中文%'

Returns empty result even though there are matching documents. Works fine with ASCII strings.

This appears to be an encoding issue in the LIKE operator implementation.

Environment: OpenSearch 2.18, SQL plugin 2.18.0

[github-actions]

Possible Duplicate

Found 1 possible duplicate issue(s):

• LIKE operator does not work with unicode characters in SQL #5 — LIKE operator does not work with unicode characters in SQL

If this is not a duplicate, please comment on this issue and the autoclose label will be removed automatically.

Otherwise, this issue will be automatically closed in 3 days.

🤖 Generated with Claude Code

[github-actions]

This issue has been automatically closed as a duplicate of #5.

If this is incorrect, please reopen this issue or create a new one.

🤖 Generated with Claude Code