[sqlite] Working with UUID

2016-04-15 Thread Cecil Westerhof
2016-04-15 19:47 GMT+02:00 Dominique Devienne : > On Fri, Apr 15, 2016 at 3:56 PM, Cecil Westerhof > wrote: > > > 2016-04-15 8:45 GMT+02:00 Dominique Devienne : > > > On Thu, Apr 14, 2016 at 9:30 PM, Cecil Westerhof < > cldwesterhof at gmail.com>> > > wrote: > > > > ?Is there a way to convert a

[sqlite] Working with UUID

2016-04-15 Thread Dominique Devienne
On Fri, Apr 15, 2016 at 3:56 PM, Cecil Westerhof wrote: > 2016-04-15 8:45 GMT+02:00 Dominique Devienne : > > On Thu, Apr 14, 2016 at 9:30 PM, Cecil Westerhof > gmail.com>> > wrote: > > ?Is there a way to convert a hex string to a blob? I did not find it yet.? > I didn't find one either (see

[sqlite] Working with UUID

2016-04-15 Thread Cecil Westerhof
2016-04-15 8:45 GMT+02:00 Dominique Devienne : > On Thu, Apr 14, 2016 at 9:30 PM, Cecil Westerhof > wrote: > > > I want to work with UUID's. (Version 4.) > > > Honestly, your post is a little vague. But maybe the following will help. > ?I am not always very good in asking questions. :'-( ? >

[sqlite] Working with UUID

2016-04-15 Thread Dominique Devienne
On Thu, Apr 14, 2016 at 9:30 PM, Cecil Westerhof wrote: > I want to work with UUID's. (Version 4.) Honestly, your post is a little vague. But maybe the following will help. > What is the smartest way to put a check on this? > check what? CHECK constraint? SQLite is dynamically typed, and to

[sqlite] Working with UUID

2016-04-14 Thread Cecil Westerhof
I want to work with UUID's. (Version 4.) What is the smartest way to put a check on this? Also: when using text to save them, you need 36 bytes instead of four bytes. When using a lot, it is better to use blob. I have to post the peculiarities I found with that another time. (For example when