UUID field in .NET API

#31

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

"PGP" <priyesh@do_not_reply> wrote

Quote:

"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh

#32

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

"PGP" <priyesh@do_not_reply> wrote

Quote:

"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh

#33

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

"PGP" <priyesh@do_not_reply> wrote

Quote:

"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh

#34

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

"PGP" <priyesh@do_not_reply> wrote

Quote:

"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh

#35

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: