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
