Re: Storing GUIDs in Oracle

Thank you very much. You're feedback is very constructive.

So are you're saying that using a RAW(16) column as a primary key would adversely affect performance? Would it cause other problems too?

Thanks!

"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.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Jul 23 2003 - 15:40:29 CDT