Attachments - Oracle

RT Developers
#1

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?

Thanks.

#2

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

#3

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

#4

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