[Rt-devel] Attachments - Oracle

[Kevin Falcone]

On Tue, Jun 07, 2011 at 04:10:19PM -0500, Scott T. Hildreth wrote:
> I did, I converted our mysql 3.8.4 => 4.0 and then used the db migration
> from Sqldeveloper to convert to Oracle.  The migration tool defines the 
> column as a BLOB, which I would think would be correct for a xls.  I
> then imported the data to the RT4 tables created by schema.Oracle.
> Maybe something went wrong there, when I download a spreadsheet the data
> is garbage.  

That's quite different from a clean RT setup.

> I just added a spreadsheet to a test ticket and was able to read it, so
> it must be the conversion that is corrupting the data. The CLOB
> definition does seem to work. 

Yes, RT encodes the data before storing it.  You'll need to do that
conversion yourself when going from mysql to oracle if you want any
old binary attachments to work.

-kevin

> 
> On Tue, 2011-06-07 at 16:34 -0400, Kevin Falcone wrote:
> > On Tue, Jun 07, 2011 at 03:21:33PM -0500, Scott T. Hildreth wrote:
> > > I believe the Content should be of type BLOB, attachments could be
> > > binary data such as a spreadsheet.
> > > 
> > > Content         CLOB,
> > > 
> > > Any reason this was defined as a CLOB?
> > 
> > Does it break in some way?
> > 
> > The definition is correct, try attaching a spreadsheet and having a
> > look at the database.  
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20110607/660d96e4/attachment.pgp>