Re: [sqlite] how do i generate a uniqueidentifier ?

"Trevor Talbot" <[EMAIL PROTECTED]> wrote: > Hm, something ate the last part of my message... > > > Note that SQLite contains a decent PRNG which is well seeded, > > if you are running on Mac or Linux. (We need to work on better > > seeding on Win32...) > > The crypto framework on recent version

Re: [sqlite] how do i generate a uniqueidentifier ?

Hm, something ate the last part of my message... > Note that SQLite contains a decent PRNG which is well seeded, > if you are running on Mac or Linux. (We need to work on better > seeding on Win32...) The crypto framework on recent versions of Windows can be used to get a good quality seed. I'm

Re: [sqlite] how do i generate a uniqueidentifier ?

On 7/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "Trevor Talbot" <[EMAIL PROTECTED]> wrote: > > > > > > sqlite> select "{" || hex(randomblob(4)) || "-" || hex(randomblob(2)) > > > > || "-" || hex(randomblob(2)) || "-" || hex(randomblob(2)) || "-" || > > > > hex(randomblob(6)) || "}"; > >

Re: [sqlite] how do i generate a uniqueidentifier ?

"Trevor Talbot" <[EMAIL PROTECTED]> wrote: > > > > sqlite> select "{" || hex(randomblob(4)) || "-" || hex(randomblob(2)) > > > || "-" || hex(randomblob(2)) || "-" || hex(randomblob(2)) || "-" || > > > hex(randomblob(6)) || "}"; > > > {4EA4A842-6ACA-0A81-5B42-F9E1D295BC27} > > Note that this is *

Re: [sqlite] how do i generate a uniqueidentifier ?

On 7/27/07, Chase <[EMAIL PROTECTED]> wrote: > hhmmm... i just noticed something weird. if i insert a string of ANY > length or format into the uniqueidentifier field, sqlite allows it... > so i guess it's just a text type under the hood with no rules enforced > on the format of the string inser

Re: [sqlite] how do i generate a uniqueidentifier ?

"Chase" <[EMAIL PROTECTED]> wrote: > how do i generate a uniqueidentifier ? > hex(randomblob(16)) -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] how do i generate a uniqueidentifier ?

hhmmm... i just noticed something weird. if i insert a string of ANY length or format into the uniqueidentifier field, sqlite allows it... insert into foobar values("{68753A44-4D6F-1225-9C60-0050E4C00067}", "Aaa", "Bbb"); insert into foobar values("whatever", "Ccc", "Ddd"); select * from f

Re: [sqlite] how do i generate a uniqueidentifier ?

Hi, Chase. On 7/27/07, Chase <[EMAIL PROTECTED]> wrote: > > idfoo bar > ___ > > {0109--0010-8000-00AA006D2EA4}"Aaa""Bbb" > I can't understand why do you need a big iden

RE: [sqlite] how do i generate a uniqueidentifier ?

ition is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Chase [mailto:[EMAIL PROTECTED] Sent: Friday, July 27, 2007 4:03 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] how do i generate a uniqueidentifier ? sorry. should have bee

Re: [sqlite] how do i generate a uniqueidentifier ?

sorry. should have been more specific. i'm talking about guids (or uuids). here's the create table line: CREATE TABLE foobar (id uniqueidentifier, foo text, bar text, PRIMARY KEY (id)); that works great, but i have not been able so far to generate a fresh guid to insert into the table.

Re: [sqlite] how do i generate a uniqueidentifier ?

Chase wrote: how do i generate a uniqueidentifier ? Define a column as follows: {fieldname} INTEGER NOT NULL PRIMARY KEY eg: CREATE TABLE hardware_types (record_key INTEGER NOT NULL PRIMARY KEY,hardware_key INTEGER default 0); -

[sqlite] how do i generate a uniqueidentifier ?

how do i generate a uniqueidentifier ? - chase - To unsubscribe, send email to [EMAIL PROTECTED] -