"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
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
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)) || "}";
> >
"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 *
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
"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]
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
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
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
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.
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);
-
11 matches
Mail list logo