Subject | Re: [Firebird-Architect] GUID Key Fields |
---|---|
Author | Ivan Prenosil |
Post date | 2005-03-24T16:04:15Z |
> The problem with CHAR(16) fields (been there doneThere used to be a bug with returning ascii 0 from UDF,
> that!) is that you run into problems with special
> characters- e.g. ASCII 0 terminates the string etc.
but afaict from short test, it has been fixed in FB1.5.2.
> While the database may handle this properly there areIf you do not mind using UDFs, then just write one function
> invariably some bugs in database libraries that
> truncate the field "by accident" (i.e. bug) so it
> really isn't a workable solution.
to generate GUID in binary form, another to convert it
to some nicer, binary-zero-free, printable format.
Do you need anything else ?
Ivan