CREATE TABLE MyTable (id_ CHAR(16) CHARACTER SET OCTETS NOT NULL);

INSERT into MyTable (id_) VALUES (gen_uuid())

TEXT TO cCmd TEXTMERGE NOSHOW PRETEXT 7			
	SELECT id_ FROM MyTable
ENDTEXT

SQLEXEC(nMyConnection, cCmd, 'MyCursor')

?id_            && Выдаёт 0h37314641443135462D443236422D3434, т.е. 16-ричную строку.
?VARTYPE(id_) + TRAN(LEN(id))  && Выдаёт Q 16, т.е. Varbinary(16), что имхо правильно.

TEXT TO cCmd TEXTMERGE NOSHOW PRETEXT 7			
	SELECT id_, KodTip, NazTip FROM MyTable
	WHERE id_ = x'37314641443135462D443236422D3434'	
ENDTEXT

qId = 0h37314641443135462D443236422D3434
?VARTYPE(qId) + TRAN(LEN(qId))  && Выдаёт те же Q 16, т.е. Varbinary(16).

TEXT TO cCmd TEXTMERGE NOSHOW PRETEXT 7			
	SELECT id_, KodTip, NazTip FROM MyTable
	WHERE id_ = ?qId
ENDTEXT

lcId = trans(qId)

TEXT TO cCmd TEXTMERGE NOSHOW PRETEXT 7			
	SELECT id_, KodTip, NazTip FROM MyTable
	WHERE id_ = ?lcId
ENDTEXT

TEXT TO cCmd TEXTMERGE NOSHOW PRETEXT 7			
	SELECT UUID_TO_CHAR(id_) as cId FROM MyTable
ENDTEXT
-- и дальше
WHERE id_ = char_to_uuid(?cId)

TEXT TO cCmd TEXTMERGE NOSHOW PRETEXT 7			
	SELECT UUID_TO_CHAR(id_) as cId FROM MyTable
ENDTEXT
-- и дальше
WHERE cId = ?lcId     /* где на фоксе было lcId = trans(qId)*/

SELECT UUID_TO_CHAR(id_) as cId FROM MyTable

CREATE TABLE Tip3 (id_ CHAR(16) CHARACTER SET OCTETS NOT NULL);
INSERT into Tip3 (id_) VALUES (gen_uuid();

SQLEXEC(gnCH, 'SELECT TOP 1 id_ FROM Tip3', 'MyCursor')

SELECT MyCursor

cId16 = id_	
* C(16): chr(36)+¸ˇß‘É@T—ÅW&ęR+chr(9)  сорри, иначе тут разметку ломает 

cId32 = STRCONV(id_, 15)
* C(32): 278F8EDF91C940549790C55726E65209

cId36 = LEFT(cId32, 8) + '-' + SUBSTR(cId32, 9,4) + '-' + SUBSTR(cId32, 13,4) ; 
        + '-' +  SUBSTR(cId32, 17,4) + '-' +  SUBSTR(cId32, 21) 
* для красоты: C(36): 278F8EDF-91C9-4054-9790-C55726E65209

qId16 = CREATEBINARY(id_)
* Q(16): 0h278F8EDF91C940549790C55726E65209


? TRANSFORM(qId16)	
* 278F8EDF91C940549790C55726E65209, т.е. =  cId32 

cCmd = "SELECT * FROM Tip3 where id_ = '" + cId16 + "'"  

cCmd = "SELECT * FROM Tip3 where id_ = ?qId16" && 

cCmd = "SELECT * FROM Tip3	where uuid_to_char(id_) = '" + cId36 + "'" 

cCmd = 'SELECT * FROM Tip3 WHERE id_ = ?cId16'

cCmd = 'SELECT * FROM Tip3 where id_ = ?STRCONV(TRANSFORM(qId16), 16)'  

cCmd = "SELECT * FROM Tip3 where id_ = x'" + TRANSFORM(qId16) + "'"   && меняем hex-префикса 0h (VFP) на x' ' (Firebird)

cCmd = "SELECT * FROM Tip3 where id_ = ?STRCONV(cId32, 16)"   && StrConv переводит в cId16


IF SQLEXEC(gnCH, cCmd, 'MyCursor2') < 0
	AERROR(aSqlErr)
	MESSAGEBOX(aSqlErr(2))
	RETURN 
ENDIF 
SELECT MyCursor2
BROWSE