Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Storing GUIDs in Oracle
I found some documentation on the ADO.NET Oracle data provider that also
leads me to believe that GUIDs are not supported.
http://www.datadirect-technologies.com/download/docs/dotnet/dotnetref/dotnetOra.html
Table 5.4 in that document shows mappings of .NET data types to OracleDB types. The entry for GUID says "not supported".
"Jeff Boenig" <jeff.boenig_at_elsitech.com> wrote in message
news:3f1e9642$1_at_btitelecom.net...
> I'm developing a .NET application that will support both MS SQL Server and
> Oracle 9i and above. I want to use GUIDs as the primary key in several
> tables. MS SQL supports this nicely using the UNIQUEIDENTIFIER data type.
> The ADO.NET OleDb data provider automatically converts it to a
System.Guid.
>
> Is it possible to store GUIDs in Oracle databases? There doesn't appear
to
> be a GUID data type in Oracle 9i. Could I store it as RAW(16)? If I do,
> would I be able to create an index on that column? Does Oracle 10i have
> support for GUID?
>
> Thanks.
>
> Jeff Boenig
> Elsinore Technologies, Inc.
> http://www.elsitech.com
>
>
>
Received on Wed Jul 23 2003 - 13:50:07 CDT