Hi All,
I am in the middle of writing a cross platform (linux, windows)
udf library to deal with uuids (guids).

I have read here before that they could be stored as char(16)
character set octets.

I have got the udf working, declared as

DECLARE EXTERNAL FUNCTION UUID_CREATE
CSTRING(17),
RETURNS PARAMETER 1
ENTRY_POINT 'fn_uuid_create' MODULE_NAME 'uuidlib';

however, if the uuid contains a #0 character the uuid is tructated.
I have tried declaring it as

DECLARE EXTERNAL FUNCTION UUID_CREATE
CHAR(16),
RETURNS PARAMETER 1
ENTRY_POINT 'fn_uuid_create' MODULE_NAME 'uuidlib';

but it still fails.

Anyone any ideas, or should I switch to storing it in human readable
form?

Regards
Ian Newby