Guid length in various providers

3 messages Options
Embed this post
Permalink
Chris Erickson-2

Guid length in various providers

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

Hello,

I was noticing that between different providers, there is a different printing of GUIDs. 

 

For example, the SQLServerSpatial provider prints them to 36 characters strings without {} braces, whereas the ArcSDE provider prints them to 38 characer strings with curly braces.

 

What is the ‘standard’ for FDO?  Is there a plan to ‘natively’ support GUIDS in FDO?

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 



_______________________________________________
fdo-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-internals
Orest Halustchak

RE: Guid length in various providers

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

Hi Chris,

 

There is no standard in FDO for this. FDO doesn’t have its own GUID type and the two providers have dealt with the types separately. But, I think these two providers follow the conventions of the underlying servers. SQL Server Mgt Studio I think displays the unique identifiers by default without braces whereas Arc desktop tools show them with braces.

 

We probably could define a convention for FDO if you have a suggestion.

 

Thanks,

Orest.

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Wednesday, October 14, 2009 6:53 PM
To: FDO Internals Mail List
Subject: [fdo-internals] Guid length in various providers

 

Hello,

I was noticing that between different providers, there is a different printing of GUIDs. 

 

For example, the SQLServerSpatial provider prints them to 36 characters strings without {} braces, whereas the ArcSDE provider prints them to 38 characer strings with curly braces.

 

What is the ‘standard’ for FDO?  Is there a plan to ‘natively’ support GUIDS in FDO?

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 



_______________________________________________
fdo-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-internals
Chris Erickson-2

RE: Guid length in various providers

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

I’m not sure I really have a suggestion, other than adding native GUID support to FDO…

 

I see the argument on the underlying providers, that at least makes sense.  ESRI actually requires ‘{‘s to be there when setting GUID fields (via strings!?) through ArcObjects.  SQL I believe uses something similar to a .NET Guid.ToString() function which leaves off the braces.

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Orest Halustchak
Sent: Thursday, October 15, 2009 7:22 AM
To: FDO Internals Mail List
Subject: [fdo-internals] RE: Guid length in various providers

 

Hi Chris,

 

There is no standard in FDO for this. FDO doesn’t have its own GUID type and the two providers have dealt with the types separately. But, I think these two providers follow the conventions of the underlying servers. SQL Server Mgt Studio I think displays the unique identifiers by default without braces whereas Arc desktop tools show them with braces.

 

We probably could define a convention for FDO if you have a suggestion.

 

Thanks,

Orest.

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Wednesday, October 14, 2009 6:53 PM
To: FDO Internals Mail List
Subject: [fdo-internals] Guid length in various providers

 

Hello,

I was noticing that between different providers, there is a different printing of GUIDs. 

 

For example, the SQLServerSpatial provider prints them to 36 characters strings without {} braces, whereas the ArcSDE provider prints them to 38 characer strings with curly braces.

 

What is the ‘standard’ for FDO?  Is there a plan to ‘natively’ support GUIDS in FDO?

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 



_______________________________________________
fdo-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-internals