[Rt-devel] Attachments - Oracle
Scott T. Hildreth
shildret at scotth.emsphone.com
Tue Jun 7 17:10:19 EDT 2011
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
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.
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
More information about the rt-devel