[Tickets #9153] Re: BYTEA DB escaping for postgres driver

[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/9153
------------------------------------------------------------------------------
  Ticket           | 9153
  Aktualisiert Von | piper at hrz.uni-marburg.de
  Zusammenfassung  | BYTEA DB escaping for postgres driver
  Warteschlange    | Horde Framework Packages
  Version          | Git master
  Typ              | Bug
  Status           | Resolved
  Priorität        | 3. High
  Milestone        | 4.0
  Patch            |
  Zuständige       | Jan Schneider
------------------------------------------------------------------------------


piper at hrz.uni-marburg.de (2011-06-22 09:17) hat geschrieben:

I observe the same problem:

if I try to synchronize Outlook(2007)-Contacts using Funambol
with Horde 4.0.6, turba 3.0.3 and postgresql-8.4. It works OK, as long  
as the Outlook-contacts do not contain photo-entries. If any of the  
contacts contains a photo, the described error occurs. This is also  
reproducable with iPhone and Funambol.

The problem seems to be the use of the function binaryToString  
(located in /usr/share/php/Horde/Db/Adapter/Postgresql/Column.php),  
which, as far as I understand the code, converts a bytea-array into an  
8bit-character-string.

I think in this case (storing of photo-data into postgresql) the  
conversion has to be reversed, from 8-bit-data to bytea-array, but  
such a function seems to be missing.

Many thanks in advance for a review of this matter,
Andreas