[GH-ISSUE #23381] issue: SQLite: Prompt tag filter fails for Cyrillic tags

GiteaMirror commented

2026-04-20 02:32:23 -05:00

Owner

Originally created by @goldkreateav on GitHub (Apr 3, 2026).
Original GitHub issue: https://github.com/open-webui/open-webui/issues/23381

Check Existing Issues

I have searched for any existing and/or related issues.
I have searched for any existing and/or related discussions.
I have also searched in the CLOSED issues AND CLOSED discussions and found no related items (your issue might already be addressed on the development branch!).
I am using the latest version of Open WebUI.

Installation Method

Git Clone

Open WebUI Version

v0.8.12

Ollama Version (if applicable)

No response

Operating System

Windows 10

Browser (if applicable)

No response

Confirmation

I have read and followed all instructions in README.md.
I am using the latest version of both Open WebUI and Ollama.
I have included the browser console logs.
I have included the Docker container logs.
I have provided every relevant configuration, setting, and environment variable used in my setup.
I have clearly listed every relevant configuration, custom setting, environment variable, and command-line option that influences my setup (such as Docker Compose overrides, .env values, browser settings, authentication configurations, etc).
I have documented step-by-step reproduction instructions that are precise, sequential, and leave nothing to interpretation. My steps:
Start with the initial platform/version/OS and dependencies used,
Specify exact install/launch/configure commands,
List URLs visited, user input (incl. example values/emails/passwords if needed),
Describe all options and toggles enabled or changed,
Include any files or environmental changes,
Identify the expected and actual result at each stage,
Ensure any reasonably skilled user can follow and hit the same issue.

Expected Behavior

Prompts tagged with Бизнес should be returned.

Actual Behavior

0 prompts returned.

Steps to Reproduce

Create a Prompt with tags including Бизнес (Cyrillic).
Go to Workspace → Prompts.
Select tag Бизнес (or call GET /api/v1/prompts/list?tag=Бизнес&page=1).
Observe that 0 prompts are returned.

Logs & Screenshots

There's no actual logs for this.

Additional Information

Root cause:
prompt.tags is stored as JSON in SQLite and may be serialized with \uXXXX escapes. Using LIKE (and/or LOWER() which is ASCII-focused in SQLite) on the serialized JSON text does not reliably match Cyrillic tag strings.

Proposed fix
Use dialect-aware JSON search:

SQLite: EXISTS (SELECT 1 FROM json_each(prompt.tags) WHERE json_each.value = :tag) (JSON1, compares decoded values)
PostgreSQL: EXISTS (SELECT 1 FROM jsonb_array_elements_text(prompt.tags::jsonb) AS tag_elem WHERE tag_elem ILIKE :tag)
Keep a fallback for other dialects.

Notes
This change fixes Cyrillic tag filtering on SQLite without relying on LOWER()/NOCASE behavior.

Originally created by @goldkreateav on GitHub (Apr 3, 2026). Original GitHub issue: https://github.com/open-webui/open-webui/issues/23381 ### Check Existing Issues - [x] I have searched for any existing and/or related issues. - [x] I have searched for any existing and/or related discussions. - [x] I have also searched in the CLOSED issues AND CLOSED discussions and found no related items (your issue might already be addressed on the development branch!). - [x] I am using the latest version of Open WebUI. ### Installation Method Git Clone ### Open WebUI Version v0.8.12 ### Ollama Version (if applicable) _No response_ ### Operating System Windows 10 ### Browser (if applicable) _No response_ ### Confirmation - [x] I have read and followed all instructions in `README.md`. - [x] I am using the latest version of **both** Open WebUI and Ollama. - [x] I have included the browser console logs. - [x] I have included the Docker container logs. - [x] I have **provided every relevant configuration, setting, and environment variable used in my setup.** - [x] I have clearly **listed every relevant configuration, custom setting, environment variable, and command-line option that influences my setup** (such as Docker Compose overrides, .env values, browser settings, authentication configurations, etc). - [x] I have documented **step-by-step reproduction instructions that are precise, sequential, and leave nothing to interpretation**. My steps: - Start with the initial platform/version/OS and dependencies used, - Specify exact install/launch/configure commands, - List URLs visited, user input (incl. example values/emails/passwords if needed), - Describe all options and toggles enabled or changed, - Include any files or environmental changes, - Identify the expected and actual result at each stage, - Ensure any reasonably skilled user can follow and hit the same issue. ### Expected Behavior Prompts tagged with Бизнес should be returned. ### Actual Behavior 0 prompts returned. ### Steps to Reproduce 1. Create a Prompt with tags including Бизнес (Cyrillic). 2. Go to Workspace → Prompts. 3. Select tag Бизнес (or call GET /api/v1/prompts/list?tag=Бизнес&page=1). 4. Observe that 0 prompts are returned. ### Logs & Screenshots There's no actual logs for this. ### Additional Information Root cause: prompt.tags is stored as JSON in SQLite and may be serialized with \uXXXX escapes. Using LIKE (and/or LOWER() which is ASCII-focused in SQLite) on the serialized JSON text does not reliably match Cyrillic tag strings. Proposed fix Use dialect-aware JSON search: SQLite: EXISTS (SELECT 1 FROM json_each(prompt.tags) WHERE json_each.value = :tag) (JSON1, compares decoded values) PostgreSQL: EXISTS (SELECT 1 FROM jsonb_array_elements_text(prompt.tags::jsonb) AS tag_elem WHERE tag_elem ILIKE :tag) Keep a fallback for other dialects. Notes This change fixes Cyrillic tag filtering on SQLite without relying on LOWER()/NOCASE behavior.