Project

General

Profile

Actions
Copy link

Defect #12349

closed

Watchers auto-complete search on non-latin chars

Added by Alexander Oryol over 11 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Jean-Philippe Lang
Category:
Database
Target version:
2.1.3
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

The current code generates SQL like as:


SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND (users.status = 1) AND (LOWER(login) LIKE '%Собо%' OR LOWER(firstname) LIKE '%Собо%' OR LOWER(lastname) LIKE '%Собо%' OR LOWER(mail) LIKE '%Собо%') LIMIT 100

So, searching user "Соболев Денис" on "Собо" as result - not found. There is the case sensitive.

Patch attached.

Files

watcher_search.patch (875 Bytes) watcher_search.patch Alexander Oryol, 2012-11-12 16:02
Actions
Copy link

Also available in: Atom PDF