For what it's worth, I use the doomdark UUID java classes under Windows
and linux with jaybird JDBC, storing the UUID as a CHAR (36) with
character set none (the leading and trailing braces that Micro$oft is so
fond of are not produced by the doomdark classes so the text
representation is two bytes shorter).

When integrated with an easy to write Hibernate Persister class, this is
a seamless mechanism that is completely transparent to my application
software and is portable across any DBMS.

On Wed, 2005-03-23 at 03:38 +0000, Firebird-Architect@yahoogroups.com
wrote:

> value inside code- not within the database
> stored procedures etc. I'd prefer to be able to
> simply retrieve a value directly into a GUID variable
> type so that any of my code can handle it as such.
>
> I don't want a "hack" of a solution- just clean
> support for it within Firebird. I'm prepared to
> wait... I don't need it right now. In fact I'm not
> switching over to Firebird just yet. I'll wait until
> it has the support that I need and then I'll start
> using it extensively. Right now I'm just playing with
> it. MS SQL Server is my "preferred" database at this
> point in time.