Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Data Type for GUID

3 posts in General Discussion Last posting was on 2003-08-22 18:06:33.0Z
D.Ahmed Posted on 2003-07-31 16:44:48.0Z
Reply-To: "D.Ahmed" <dabdurazack@siemens-hearing.com>
From: "D.Ahmed" <dabdurazack@siemens-hearing.com>
Newsgroups: ianywhere.public.general
Subject: Data Type for GUID
Lines: 9
Organization: Siemens Hearing Instruments
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: host71.siemens-hearing.com
X-Original-NNTP-Posting-Host: host71.siemens-hearing.com
Message-ID: <3f294780$1@forums-1-dub>
Date: 31 Jul 2003 09:44:48 -0700
X-Trace: forums-1-dub 1059669888 65.192.162.71 (31 Jul 2003 09:44:48 -0700)
X-Original-Trace: 31 Jul 2003 09:44:48 -0700, host71.siemens-hearing.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1490
Article PK: 3720

Hi

I am planning to add a column in a table which will hold a GUID. What is
data type I should be using ? We are presently working on ASA 7.0.3.2057

Thanks,
DAN


Raymond Kwong Posted on 2003-08-14 13:56:16.0Z
From: "Raymond Kwong" <raymond.kwong@sybase.com>
Newsgroups: ianywhere.public.general
References: <3f294780$1@forums-1-dub>
Subject: Re: Data Type for GUID
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: rkwong-pc.sybase.com
Message-ID: <3f3b9505$1@forums-2-dub>
X-Original-Trace: 14 Aug 2003 06:56:21 -0700, rkwong-pc.sybase.com
NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
Date: 14 Aug 2003 06:56:16 -0700
X-Trace: forums-1-dub 1060869376 10.22.241.42 (14 Aug 2003 06:56:16 -0700)
X-Original-Trace: 14 Aug 2003 06:56:16 -0700, forums-2-dub.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1606
Article PK: 3834

GUID is not in itself a data type back in 7.x, so you have 2 choices:

1. Define the GUID column to use the binary(16) data type and dump the hex
values in there; or

2. Just put the whole guid into a string and process it with one of the
character data types (char, varchar, text, long varchar...)

Version 8 and 9 of the ASA includes a new datatype called UNIQUEIDENTIFIER
specifically designed to handle GUIDs.

Raymond Kwong
iAnywhere Solutions

"D.Ahmed" <dabdurazack@siemens-hearing.com> wrote in message
news:3f294780$1@forums-1-dub...
> Hi
>
> I am planning to add a column in a table which will hold a GUID. What is
> data type I should be using ? We are presently working on ASA 7.0.3.2057
>
> Thanks,
> DAN
>
>


VBM Posted on 2003-08-22 18:06:33.0Z
From: "VBM" <legendnews@lycos.co.uk>
Newsgroups: ianywhere.public.general
References: <3f294780$1@forums-1-dub> <3f3b9505$1@forums-2-dub>
Subject: Re: Data Type for GUID
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 12.25.165.67
X-Original-NNTP-Posting-Host: 12.25.165.67
Message-ID: <3f465ba9$1@forums-1-dub>
Date: 22 Aug 2003 11:06:33 -0700
X-Trace: forums-1-dub 1061575593 12.25.165.67 (22 Aug 2003 11:06:33 -0700)
X-Original-Trace: 22 Aug 2003 11:06:33 -0700, 12.25.165.67
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1658
Article PK: 3883

I am using GUID as char(36) in ASA 7.0.4

thanks

Raymond Kwong wrote:
> GUID is not in itself a data type back in 7.x, so you have 2 choices:
>
> 1. Define the GUID column to use the binary(16) data type and dump
> the hex values in there; or
>
> 2. Just put the whole guid into a string and process it with one of
> the character data types (char, varchar, text, long varchar...)
>
> Version 8 and 9 of the ASA includes a new datatype called
> UNIQUEIDENTIFIER specifically designed to handle GUIDs.
>
> Raymond Kwong
> iAnywhere Solutions
>
>
>
> "D.Ahmed" <dabdurazack@siemens-hearing.com> wrote in message
> news:3f294780$1@forums-1-dub...
>> Hi
>>
>> I am planning to add a column in a table which will hold a GUID.
>> What is data type I should be using ? We are presently working on
>> ASA 7.0.3.2057
>>
>> Thanks,
>> DAN