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

[Emmanuel Lacour]

On Mon, May 17, 2010 at 01:53:43PM +0200, Václav Ovsík wrote:
> 
> 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 :(.
> 

yes :(

Maybe there is a better way as of recent postgres?

AW, I did a migration from mysql to postgres 8.3 with base64 conversion
and everything is ok.