[sqlite] spanish chars

I haven't worked with internationalization much before so please forgive me if this is a stupid question or not related to sqlite. I have an charset problem using sqlite 3.2.2, I run into the following issue: we have started adding spanish transaltions to our database. The app that loads the

[sqlite] transaction w/ large journal fails

I am running into a situation where on linux (fc5 and debian3) I have a transaction that is consistently failing using sqlite 3.3.7. The same transaction completes on windows every time. I have a large database (1.2gb) that i run a transaction on. In windows the journal file for this transaction

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

There is an ongoing debate on this subject at Lambda the Ultimate. One approach that is sound is to introduce a new static type, called DYNAMIC, that permits any value. Summarizing and seconding Dennis Cote's suggestion, perhaps columns that have no type declared, or that are declared DYNAMIC,

RE: [sqlite] CHECK constraints

MS SQL 2000 wil alsol insert (5, NULL) From: "Marcus Welz" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: Subject: RE: [sqlite] CHECK constraints Date: Wed, 2 Nov 2005 19:24:09 -0500 PostgreSQL 8.0 will happily insert (5, NULL). -Original

RE: [sqlite] Request for comment: Proposed SQLite API changes

I would be in favor of both changes. Any other hints about what is in the works for 3.3.0? I haven't upgraded past 3.2.2 because the optimizer changes made my application hang and i haven't had a chance to re-write & test all of my queries. Any changes in 3.3.0 that would allow me to upgrade

RE: [sqlite] BEGIN TRANSACTION name

From: "Marcus Welz" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: Subject: RE: [sqlite] BEGIN TRANSACTION name Date: Thu, 3 Nov 2005 12:46:39 -0500 I actually have a question regarding nested transactions. Maybe I'm missing something, but isn't it true that

RE: [sqlite] How dangerous is PRAGMA Synchronous OFF?

If the power never goes out and no programs ever crash on you system then Synchronous = OFF is for you, but the rest of the world might still want it ON. Really it sounds like the thing you need to worry about most is the unexpected termination of your program. If you aren't worried about

RE: [sqlite] Which VC6 options to use for fastest sqlite3?

since you have /MT i am assuming you will need /D "THREADSAFE". If you are used to MSVC and want to try another compiler i would suggest grabbing http://www.codeblocks.org, it is an IDE and you can import you MSVC project into it and compile with the MinGW/gcc compiler, which it will set up for