Storing MySQL GUID/UUIDs

From MySQL 8.0 and above you could use UUID_TO_BIN: UUID_TO_BIN(string_uuid), UUID_TO_BIN(string_uuid, swap_flag) Converts a string UUID to a binary UUID and returns the result. (The IS_UUID() function description lists the permitted string UUID formats.) The return binary UUID is a VARBINARY(16) value. CREATE TABLE t (id binary(16) PRIMARY KEY); INSERT INTO t VALUES(UUID_TO_BIN(UUID(), true)); INSERT … Read more

Invalid Binary Itunes Connect [duplicate]

check up your mailbox associated with your apple developer account, apple will send email to your mailbox with some diagnose information and how to solve your problem. for me, apple send following diagnose information. I actually have never touched iCound, which is really confusing. after all, I created a new app id without Wild-card character, … Read more

binary sed replacement

bbe is a “sed for binary files”, and should work more efficiently for large binary files than hexdumping/reconstructing. An example of its use: $ bbe -e ‘s/original/replaced/’ infile > outfile Further information on the man page.