Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-01 : 07:52:53
|
| Derick Bailey writes "We're trying to set a new standard at my office, of using GUIDs as database ID fields - all new tables in all databases will have a GUID as the ID field, using the UniqueIdentifier data type.The problem that we are running into, is that different applications interpret the UniqueIdentifier data type differently - ADO 2.x interprets it with the opening and closing { } braces. ADO.NET does not include the { and } in the GUID structure, SQL Server Query Analyzer does not include the { } braces, and SQL Server Enterprise Manage does include the { }so we end up with results like this:ADO 2.x: {012345678-abcd-ef01-2345-6789abcd}ADO.NET: 012345678-abcd-ef01-2345-6789abcdQuery Analyzer: 012345678-abcd-ef01-2345-6789abcdEnterprise Manager: {012345678-abcd-ef01-2345-6789abcd}The problem with this is in two parts:1) VB6 does not have a GUID structure or data type, so we are treating GUIDs as strings... but VB6 doesn't recognize "{012345678-abcd-ef01-2345-6789abcd}" and "012345678-abcd-ef01-2345-6789abcd" as the same string2) when sending a URL link through an email, the { } braces break the link - in all email applications that we have tested. This include Groupwise 6, Groupwise 6.5, IPSwitch Web IMail, Outlook 2000, and Outlook Express (IE 6).We're becoming very frustrated with the problems at hand, and need to know how others have worked around these problems. Do you have any real life situations where you have encountered this and found a solution, etc?Thanks." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-03-01 : 07:56:11
|
| Maybe you should re-think your standard.>> all new tables in all databases will have a GUID as the ID fieldBad ideaYou should have a database access layer in your apps which can convert this as necessary.You should make all access to sql server tables via stored procedures which can also give a presentation convertion - often to a character field for guids.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|
|
Frustration with UniqueIdentifier