Re: [sqlite] Appropriate uses for SQLite

2007-02-05 Thread Chris Hanson
On Feb 2, 2007, at 8:59 AM, Clark Christensen wrote: FWIW, I'm not convinced Samba has locking working correctly. Using a very recent Samba version, I managed to corrupt a SQLite database last fall by (I think) doing simultaneous writes from the Linux host box, and my WinXP client box

Re: [sqlite] Re: Unicode Help

2006-12-07 Thread Chris Hanson
On Dec 5, 2006, at 8:42 AM, Igor Tandetnik wrote: Da Martian <[EMAIL PROTECTED]> wrote: So if I look at a name with umlaughts in the database via sqlite3.exe I get: Städt. Klinikum Neunkirchen gGmbH -- | an "a" with two dots on top "A with umlaut" is represented as two bytes in

Re: [sqlite] Q about new SQLite API

2006-11-07 Thread Chris Hanson
On Nov 7, 2006, at 5:17 AM, [EMAIL PROTECTED] wrote: QUESTION 1: sqlite3_prepare_v2 is the merely the working name for the new function. What should the official name be? What about introducing an options mechanism in place of a second prepare mechanism? Do you foresee any situations

Re: [sqlite] Wish to store a C structure in sqlite column

2006-09-24 Thread Chris Hanson
On Sep 21, 2006, at 7:18 AM, Narendran wrote: as far as my knowledge SQLITE allows me to declare the column types suppoted by the programming languare or say i am using blob . My requirement is i wish to store a structure in the SQLite column. Instead of storing the structure in a single

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

2005-11-02 Thread Chris Hanson
On Nov 2, 2005, at 7:36 AM, [EMAIL PROTECTED] wrote: Am I alone in thinking that a division operator that does different things depending on the declared datatype of a column is an abomination? I don't think you're alone. I do think you're wrong. By declaring column a as INTEGER, and column