I think you need 3.3.8 or greater.
On Mon, 2007-03-26 at 07:39 +0200, stephan nies wrote:
> I am using sqlite 3.3.5 .
>
> On 3/25/07, Eric Pankoke <[EMAIL PROTECTED]> wrote:
> >
> > What version of SQLite are you using? I'm not sure the IF EXISTS option
> > was present until a certain version o
I am using sqlite 3.3.5 .
On 3/25/07, Eric Pankoke <[EMAIL PROTECTED]> wrote:
What version of SQLite are you using? I'm not sure the IF EXISTS option
was present until a certain version of 3.x (though I'm not sure which
version).
Eric Pankoke
Founder
Point Of Light Software
http://www.polsoft
Hi,
I'm trying to install SQLite in order to use Trac with our SVN repositories.
We're running RedHat 4 Ent.
I downloaded the source code file sqlite-3.3.13.tgz and followed the README on
how to compile
but ran into the problem that the header file "tcl.h" could not be found, even
though I h
SQLite doesn't truncate anything. Whatever you put in you get out. If
you see a truncation, it is either done by whatever wrapper you use on
top of SQLite, or simply an artifact of the way you inspect the data
(e.g. you look at the string in a debugger, and the debugger just
happens to show on
On 3/25/07, John Fisher <[EMAIL PROTECTED]> wrote:
I note from the home page that "Transactions are atomic, consistent,
isolated, and durable (ACID) even after system crashes and power failures".
Is this still the case if the database is stored on a flash file system, say
JFFS2 with the linux ker
I note from the home page that "Transactions are atomic, consistent,
isolated, and durable (ACID) even after system crashes and power failures".
Is this still the case if the database is stored on a flash file system, say
JFFS2 with the linux kernel?
--
Thank you for the reply.
Is doing a SELECT EXISTS (...) faster than a SELECT COUNT (... LIMIT 1)
or would it be the same (I would expect them to be the same, but that's
only my guess)?
Regards,
Dennis
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Saturda
At 9:42 PM +0200 3/25/07, Ralph Müller wrote:
to store (german) Text in a SQLite Database, is it better to use
UTF-8 or is ISO-8859-1 more recommendable?
It is recommended to use UTF-8 no matter what
language text is in the database, since it is
fully adaptable to any situation. Also, with
Ralph Müller schrieb:
Hi all,
to store (german) Text in a SQLite Database, is it better to use
UTF-8 or is ISO-8859-1 more recommendable?
UTF-8.
Frank
-
To unsubscribe, send email to [EMAIL PROTECTED]
Hi all,
to store (german) Text in a SQLite Database, is it better to use
UTF-8 or is ISO-8859-1 more recommendable?
Thx in advance 4 help.
Cheers!
Ralph
PS: Please excuse my terrible english. Thx.
-
To unsubscribe, s
What version of SQLite are you using? I'm not sure the IF EXISTS option
was present until a certain version of 3.x (though I'm not sure which
version).
Eric Pankoke
Founder
Point Of Light Software
http://www.polsoftware.com/
-Original Message-
From: stephan nies [mailto:[EMAIL PROTECTE
Hello,
when i build a test table with:
CREATE TABLE test(a text);
and try to implement a trigger using:
CREATE TRIGGER IF NOT EXISTS trig_name
BEFORE INSERT ON test
FOR EACH ROW BEGIN
SELECT RAISE(ROLLBACK, 'blabla')
WHERE NEW.a = 'pong';
END;
I get this error message:
SQL error: near "NOT": s
Rich Rattanni wrote:
On 3/24/07, John Stanton <[EMAIL PROTECTED]> wrote:
Andrew Finkenstadt wrote:
> On 3/24/07, John Stanton <[EMAIL PROTECTED]> wrote:
>
>>
>> Compilers do not terminate strings, library functions do.
>
>
>
> You are guaranteed by the C standard that the string referred to by
fangles <[EMAIL PROTECTED]> wrote:
When I have text pasted into an sqlite string field, it is stored
okay but when I retrieve a string, it is truncated at the first CR
(0D).
SQLite doesn't truncate anything. Whatever you put in you get out. If
you see a truncation, it is either done by whateve
Simplified I have the following situation:
2 tables, tableA and tableB both with an integer field, called ID, holding
unique integer numbers in tableA and non-unique integer numbers in tableB.
Both tables have an index on this field and for tableA this is an INTEGER
PRIMARY KEY.
Now I need to dele
I use SQLite 3.1.15
Build 1.0.1911.21749
-Ursprungligt meddelande-
Från: stripe [mailto:[EMAIL PROTECTED]
Skickat: den 25 mars 2007 10:22
Till: sqlite-users@sqlite.org
Ämne: Re: [sqlite] sqlite and bcc32
using sqlite version 3.3.13.
.. extern "C" { #include } ...
doesn't help :(
-
using sqlite version 3.3.13.
... extern "C" { #include } ...
doesn't help :(
--
View this message in context:
http://www.nabble.com/sqlite-and-bcc32-tf3458305.html#a9658088
Sent from the SQLite mailing list archive at Nabble.com.
--
17 matches
Mail list logo