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.
GiteaMirror
added the bug label 2026-05-18 05:28:22 -05:00
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Originally created by @goldkreateav on GitHub (Apr 3, 2026).
Original GitHub issue: https://github.com/open-webui/open-webui/issues/23381
Check Existing Issues
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
README.md.Expected Behavior
Prompts tagged with Бизнес should be returned.
Actual Behavior
0 prompts returned.
Steps to Reproduce
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.