[Tickets #9323] Re: Searching for groups with non ascii chars

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/9323
------------------------------------------------------------------------------
  Ticket           | 9323
  Aktualisiert Von | sebastian.radish at gmx.de
  Zusammenfassung  | Searching for groups with non ascii chars
  Warteschlange    | Horde Framework Packages
  Version          | FRAMEWORK_3
  Typ              | Bug
  Status           | Feedback
  Priorität       | 1. Low
  Milestone        |
  Patch            |
  Zuständige      | Jan Schneider
------------------------------------------------------------------------------


sebastian.radish at gmx.de (2010-10-21 13:10) hat geschrieben:

->exists($group) is now working.

Unfortunatly, ->getGroupId($group) also failed till I added a similar  
line to the "_getId" function.

My diff looks like this know:
----------------------------------------------
--- a/horde/lib/Horde/DataTree/sql.php  2010-04-28 15:39:38.000000000 +0200
+++ b/horde/lib/Horde/DataTree/sql.php  2010-10-21 19:05:31.000000000 +0200
@@ -391,6 +391,7 @@
          $query = 'SELECT datatree_id FROM ' . $this->_params['table'] .
              ' WHERE group_uid = ? AND datatree_name = ? AND  
datatree_parents = ?';

+        $object_name = String::convertCharset($object_name,  
NLS::getCharset(), $this->_params['charset']);
          $object_names = explode(':', $object_name);
          $object_parents = '';
          foreach ($object_names as $name) {
@@ -422,6 +423,7 @@
              . ' AND datatree_parents = ?';

          $ids = array();
+        $name = String::convertCharset($name, NLS::getCharset(),  
$this->_params['charset']);
          $parts = explode(':', $name);
          foreach ($parts as $part) {
              $result = $this->_db->getOne($query,  
array($this->_params['group'], $part, count($ids) ? ':' . implode(':',  
$ids) : ''));