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

[Jesse Vincent]

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...