[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
(ITS#8247) ru_RU.UTF-8 search problem
Full_Name: Oleg Smirnov
Version: 2.4.42
OS: linux ubuntu
URL: ftp://ftp.openldap.org/incoming/
Submission from: (NULL) (37.147.131.107)
When searching for Russian words confused Tupper And tolower functions:
See to end of the select, russian word wrote in low case:
"upper(...) like '%low case%'"
55f9ebc5 Constructed query: SELECT DISTINCT
ldap_entries.id,ldapx_persons.id,text('inetOrgPerson') AS
objectClass,ldap_entries.dn AS dn FROM ldap_entries,ldapx_persons WHERE
ldapx_persons.id=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND
upper(ldap_entries.dn) LIKE upper('%'||?) AND ldapx_persons.lang=0 AND
(upper(ldapx_persons.surname) LIKE
'%бугров%')