[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:54) hat geschrieben:

On second thought I see, that my assumption is wrong: the function  
binaryToString is used when reading the (already broken)  
postgresql-data, therefore this conversion is completely correct.

The error occurs when storing the photo-data into postgresql, where  
the conversion is done by the function Horde_Db_Value_Binary  
(/usr/share/php/Horde/Db/Value/Binary.php). Maybe a special  
postgresql-handling has to be done there?

The photo-data which are stored in my postgresql-DB are all NULL

Andreas
>
> 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