[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) (

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