[rt-devel] Rt and Oracle

Dylan Vanderhoof DylanV at semaphore.com
Wed Apr 12 04:06:40 EDT 2000

I can't speak for Oracle, but I know that DB2 has support for the BLOB type,
althought it akes fairly excessive use of binds.  I'll have to de some
research for that.
Also, I have a trigger for DB2 that will likely work with Oracle as well
with some tweaking to emulate MySQL's AUTO_INCREMENT column variable.

Dylan C. Vanderhoof
Internal Software Developer
Semaphore Corporation

-----Original Message-----
From: Tobias Brox [mailto:tobiasb at tobiasb.funcom.com]
Sent: Wednesday, April 12, 2000 1:04 AM
To: Jesse
Cc: Aryeh Cody Sherr; Dylan Vanderhoof; 'rt-devel at lists.fsck.com'
Subject: Re: [rt-devel] Rt and Oracle

> Other issues that need to be dealt with is the fact that the Attachments
> table uses MySQL's blob support which may or may not be easily portable. 

Another issue is the primary keys.  MySQL has "autoincrement" which means
that a NULL value might be issued for the primary key, and MySQL will find
the number itself and return it.  Different engines do have different ways
of handling this, as well as different ways of returning the number.

Tobias Brox 
aka TobiX
+47 22 925 871

More information about the Rt-devel mailing list