"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:2kqthvcvga18jsbcc5qmgs99rgdi96rb90_at_4ax.com...
> On Wed, 23 Jul 2003 14:21:28 -0400, "Jeff Boenig"
> <jeff.boenig_at_elsitech.com> wrote:
>
> >There isn't a straightforward answer to my questions in the SQL
Reference. I
> >want to design my database to work equally well with MS-SQL and Oracle,
> >which is why I thought posting these questions on this newsgroup would be
a
> >constructive thing to do.
>
> As MS-SQL and Oracle are two completely different architectures, and
> apart from PL/SQL Oracle treats the RAW(16) as a VARCHAR2, requiring
> implicit conversion all the time,. you are going to end up in hell.
> Please reconsider.
UUIDs can also be stored in ascii hexdecimal format, this gets around
implicit conversions but of course requires more storage.
Received on Wed Jul 23 2003 - 15:39:25 CDT
