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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Unique identifier: binary to string

Author  Topic  swan Starting Member 11 Posts Posted - 2003-07-03 : 12:58:48 I use SQL Server to generate unique identifiers, which I store in a binary format in a different database (PostreSQL). I need to retrieve this binary data via JDBC and convert it to a string (e.g. '6F9619FF-8B86-D011-B42D-00C04FC964FF') the same way SQL Server does it. I can retrieve the binary data in my Java program, but I don't know what algorithm to use in order to convert it to a string representation. Any help will be greatly appreciated. Thanks. Oleg