On Mon, May 17, 2010 at 02:10:43PM +0200, Emmanuel Lacour wrote:
Maybe there is a better way as of recent postgres?
FYI: fwd
--
Zito
---BeginMessage---
* Václav Ovsík:
Is it possible that binding of binary data-type (bytea) without
data-type specification would behave like in MySQL in some
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).
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.
On Mon, May 17, 2010 at 02:10:43PM +0200, Emmanuel Lacour wrote:
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
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
Dear Users and Developers,
I'm facing a migration four instances RT 3.2.2 to RT 3.8.8 with a number
of customizations.
Back-end database is MySQL and I have prepared a script for loading
database dumps from old MySQL 3.23.58 to 5.0.51 (Debian Lenny)
and then upgrading RT schema
On Fri, May 14, 2010 at 11:43:35PM +0200, Václav Ovsík wrote:
Dear Users and Developers,
I'm facing a migration four instances RT 3.2.2 to RT 3.8.8 with a number
of customizations.
Back-end database is MySQL and I have prepared a script for loading
database dumps from old MySQL 3.23.58 to