I can generate the GUID as a 16 byte hex string, so the dashes are no problem. I'm working with VEE (similar to LabView) and .Net, so a lot of the mundane stuff is done for me with nifty little methods like ToArray(), ToString(), etc..
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of RSmith Sent: Tuesday, April 22, 2014 1:57 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] BLOBs and NULLs On 2014/04/22 19:12, Richard Hipp wrote: > On Tue, Apr 22, 2014 at 1:07 PM, Drago, William @ MWG - NARDAEAST < > william.dr...@l-3com.com> wrote: > >> Does blob ignore them if they are included? >> > No. That would be a syntax error. The dashes in (strict) GUIDs are > an arbitrary construct (perhaps originally designed to promote > readability - as if anybody ever actually reads a GUID). If you want > to store the GUID as a BLOB then you'll have to strip the dashes > yourselve (in your > application) and do the hex-to-binary conversion yourself. Just to add - I cannot imagine why you would have dashes to start with, do you have a GUID generator that pumps out TEXT or STRING values? Usually they should be accompanied (in most libraries) by a function that pops out the actual 16/20/32-byte BLOB as a stream or array of bytes/integers/whatever, and it usually involves some cost to convert it to strings with dashes etc. - a nice optimisation if those are no longer needed. If you DO only get them as string though, the web is full of little bits of conversion code, and we will be glad to supply you with some too if you say which environment, function, etc. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users