[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: (ITS#4604) backs-sql: backsql_process_filter(): invalid filter for UTF-8 querys



On Sat, 2006-07-01 at 08:07 +0000, reiffert@student.physik.uni-mainz.de
wrote:
> Full_Name: Thomas Reifferscheid
> Version: 2.3.24
> OS: Linux/2.6.16
> URL: http://student.physik.uni-mainz.de/~reiffert/back_sql.txt
> Submission from: (NULL) (84.168.189.212)
> 
> 
> I'm using Thunderbird as slapd frontend.
> When searching for an recipient whose name contains special chars
> like "üöä" (german umlauts), the slapd's syslog correctly shows the utf-8
> encoded
> characters.
> 
> slapd then hands over the filter to back-sql which then returns
> "invalid filter".
> 
> 
> When searching for "M*ller", so replacing "ü" by "*", the answers
> that get back to thunderbird, correctly show "Müller".
> 
> 
> A loglevel 65535 output from a "mül" search can be found
> at the provided URL.

back-sql acts as a "dumb" backend to a generic RDBMS; LDAP requires UTF8
for directory strings, while the RDBMS uses whatever instructed to.  You
need to make sure appropriate conversion occurs in between.  Back-sql
does not provide any means to convert strings to/from another character
set.  A patch that consistently enables translitteration from UTF8 to
whatever charset is used in the RDBMS for a given data type is welcome,
provided it complies with the license and other contribution criteria of
OpenLDAP software.

p.




Ing. Pierangelo Masarati
Responsabile Open Solution
OpenLDAP Core Team

SysNet s.n.c.
Via Dossi, 8 - 27100 Pavia - ITALIA
http://www.sys-net.it
------------------------------------------
Office:   +39.02.23998309          
Mobile:   +39.333.4963172
Email:    pierangelo.masarati@sys-net.it
------------------------------------------