[rt-users] dumpfile-to-rt-3.0 problem: parser: unterminated quoted string

[Alexei Barantsev]

  > -----Original Message-----
  > From: Jesse Vincent [mailto:jesse at bestpractical.com] 
  > Sent: Tuesday, July 13, 2004 7:06 PM
  > To: Alexei Barantsev
  > Cc: rt-users at lists.bestpractical.com
  > Subject: Re: [rt-users] dumpfile-to-rt-3.0 problem: parser: 
  > unterminated quoted string
  > 
  > On Tue, Jul 13, 2004 at 05:18:56PM +0400, Alexei Barantsev wrote:
  > > Could anybody explain me how is it supposed to put binary 
  > attachments 
  > > to the DB?
  > > 
  > > Postgres schema defines the 'content' column of the 'attachments' 
  > > table having 'text' type, MySQL schema defines is as 
  > 'longtext'. Both 
  > > these types are character ones and don't allow arbitrary 
  > binary data. 
  > > How is it possible to put actual attachment content to 
  > such fields? 
  > > Maybe there is a trick here? Where can I read about it?
  > 
  > 
  > Using the rt2-to-rt3 toolkit to move between mysql and Pg 
  > isn't really supported. That's what it looks like you're 
  > doing. The two databases have different encoding requirements...
  > 

No, I'm moving from Postgres to Postgres. I just mentioned MySQL to show
that both these database scemas don't allow for storing binary data to the
'content' field.

-- 
Alexei Barantsev
UniTesK Product Line Manager, ISP RAS
mailto: barancev at ispras.ru
Phone : +7(095)912-5317(ext 4422)
Web   : http://unitesk.com/