i want to run the following query
insert into texts(text_guid,text_data) values (:text_guid,:text_data);
where
text_guid is declared as VARBINARY(16) in MySQL db 5.5
text_data is declared as TEXT
i have created a TGuid, and converted it to a TBytes variable. And now i want now to pass the TBytes variable's value to the TSQLQuery with a ParamByName('text_guid') but ParamByName has no AsBytes property like TField. How should i handle this ?
I use VARBINARY(16) for economy and not VARCHAR(38) for guids so .AsString or AsGuid is not a option (i think).