UUID field in .NET API

#41

Mike,

1. It is declared as a unique identifier.

2. To test, i generated them (using guidgen, a tool that ships with visual
studio), and copy pasted the string in sybase central using the edit on the
column.

Priyesh.

"Mike Vander Ploeg" <mvanderp_asdf (AT) sybase (DOT) com> wrote

Quote:

Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

#42

Mike,

1. It is declared as a unique identifier.

2. To test, i generated them (using guidgen, a tool that ships with visual
studio), and copy pasted the string in sybase central using the edit on the
column.

Priyesh.

"Mike Vander Ploeg" <mvanderp_asdf (AT) sybase (DOT) com> wrote

Quote:

Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

#43

Mike,

1. It is declared as a unique identifier.

2. To test, i generated them (using guidgen, a tool that ships with visual
studio), and copy pasted the string in sybase central using the edit on the
column.

Priyesh.

"Mike Vander Ploeg" <mvanderp_asdf (AT) sybase (DOT) com> wrote

Quote:

Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

#44

Mike,

1. It is declared as a unique identifier.

2. To test, i generated them (using guidgen, a tool that ships with visual
studio), and copy pasted the string in sybase central using the edit on the
column.

Priyesh.

"Mike Vander Ploeg" <mvanderp_asdf (AT) sybase (DOT) com> wrote

Quote:

Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

#45

Mike,

1. It is declared as a unique identifier.

2. To test, i generated them (using guidgen, a tool that ships with visual
studio), and copy pasted the string in sybase central using the edit on the
column.

Priyesh.

"Mike Vander Ploeg" <mvanderp_asdf (AT) sybase (DOT) com> wrote

Quote:

Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

#46

"PGP" <priyesh@do_not_reply> wrote in news:48e396d5@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> 2. To test, i generated them (using guidgen, a tool that ships with
P> visual studio), and copy pasted the string in sybase central using the
P> edit on the column.

Interesting.

Can you compare you results to doing something like this:

INSERT INTO your_guid (your_guid_col)
VALUES ( NEWID() );

And see if you get different behaviour.
The NEWID() function is the SQL way of creating a new GUID/UUID.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

#47

"PGP" <priyesh@do_not_reply> wrote in news:48e396d5@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> 2. To test, i generated them (using guidgen, a tool that ships with
P> visual studio), and copy pasted the string in sybase central using the
P> edit on the column.

Interesting.

Can you compare you results to doing something like this:

INSERT INTO your_guid (your_guid_col)
VALUES ( NEWID() );

And see if you get different behaviour.
The NEWID() function is the SQL way of creating a new GUID/UUID.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

#48

"PGP" <priyesh@do_not_reply> wrote in news:48e396d5@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> 2. To test, i generated them (using guidgen, a tool that ships with
P> visual studio), and copy pasted the string in sybase central using the
P> edit on the column.

Interesting.

Can you compare you results to doing something like this:

INSERT INTO your_guid (your_guid_col)
VALUES ( NEWID() );

And see if you get different behaviour.
The NEWID() function is the SQL way of creating a new GUID/UUID.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

#49

"PGP" <priyesh@do_not_reply> wrote in news:48e396d5@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> 2. To test, i generated them (using guidgen, a tool that ships with
P> visual studio), and copy pasted the string in sybase central using the
P> edit on the column.

Interesting.

Can you compare you results to doing something like this:

INSERT INTO your_guid (your_guid_col)
VALUES ( NEWID() );

And see if you get different behaviour.
The NEWID() function is the SQL way of creating a new GUID/UUID.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

#50

"PGP" <priyesh@do_not_reply> wrote in news:48e396d5@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> 2. To test, i generated them (using guidgen, a tool that ships with
P> visual studio), and copy pasted the string in sybase central using the
P> edit on the column.

Interesting.

Can you compare you results to doing something like this:

INSERT INTO your_guid (your_guid_col)
VALUES ( NEWID() );

And see if you get different behaviour.
The NEWID() function is the SQL way of creating a new GUID/UUID.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList