[Rt-devel] Attachments - Oracle

[Scott T. Hildreth]

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.  

...

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. 




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.  
> 
> -kevin
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel