On Sat, May 15, 2010 at 01:35:36PM +0200, Václav Ovsík wrote: > Hi Emmanuel, > thanks for your reply. > > On Sat, May 15, 2010 at 07:23:01AM +0200, Emmanuel Lacour wrote: > > With Pg, this content is handled specifically, see _EncodeLOB in > > lib/RT/Record.pm. > > > > (see also mysql2Pg page on RTwiki). > > I saw Base64 encoding in script on wiki page and also elsewhere, but > considered that as workaround to store binary data into Pg text > type-field. > > Are you sure, that _EncodeLOB is used only for Pg?
Oh yes, I was blind that RT uses DBIx::SearchBuilder. There is a subroutine BinarySafeBLOBs defined in DBIx::SearchBuilder::Handle::Pg.pm and returns undef. That is - Pg is considered not capable handling binary in safe manner. Every value must be converted using base64 :(. Regards -- Zito Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
