[rt-users] Migration from MySQL to PostgreSQL - Pg datatypes for blobs?

[Václav Ovsík]

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