[sqlite] "datatype mismatch" error

I'm trying to insert some UTF-16 into my database but I'm getting a "datatype mismatch" error when I call sqlite3_step() after i bind the string with sqlite3_bind_text16(). anyone know why this would happen?

Re: [sqlite] How are NULL values deleted?

Hello Vladimir and Ulrik, On Oct 28, 2004, at 01:01, Vladimir Vukicevic wrote: You need to use "IS NULL" as opposed to "= NULL". Thanks so much. Works like a charm :-) Regards, -- Tito

Re: [sqlite] How are NULL values deleted?

You need to use "IS NULL" as opposed to "= NULL". - Vlad On Thu, 28 Oct 2004 00:55:39 +0200, Tito Ciuro <[EMAIL PROTECTED]> wrote: > Hello, > > I'd like to remove all rows with a specific column equaling NULL. I've > tried this: > > SQLite version 3.0.8 > Enter ".help" for instructions >

[sqlite] How are NULL values deleted?

Hello, I'd like to remove all rows with a specific column equaling NULL. I've tried this: SQLite version 3.0.8 Enter ".help" for instructions sqlite> select * from address; Ciuró|1|Javi||España Garaicoechevarria|2|Ana||España Ciuró|3|Tito||España Miti|4|Sam||Italy Schmuck|5|Joe||Germany sqlite>

Re: [sqlite] a bunch of questions about SQLite from new user

Vladimir, Thank you for your responses. One short followup: A. what happens to the zSql? Is it copied or it is assumed that this is a static text? Suppose I call sqlite3_prepare in one place and immediately release dynamically allocated text. sqlite3_prepare parses only the first statement. Then

[sqlite] SQLite & Palm???

Hi, I'm quite new to both Palm programming and SQLite, and I am planning to write a calendar application that collaborates with calendar application a college of mine has written: http://www.tnt.uni-hannover.de/~pahl/calendar/overview.html (sorry, web site only in German) The calendar data is

RE: [sqlite] Index Usage

Great Question! I am eager to hear the response! I use a ton of JOINs and INTERSECTs. Coverage on that topic would be great too! -Original Message- From: William Hachfeld [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 9:34 AM To: [EMAIL PROTECTED] Subject: [sqlite] Index

Re[2]: [sqlite] Index question

On Wed, 27 Oct 2004, Taka Muraoka wrote: >UP> Hi Taka, > >>> >>> These are stored in tables like this: >>> >>> CREATE TABLE object >>> ( >>> object_id INTEGER PRIMARY KEY >>> ) ; >>> >>> CREATE TABLE item >>> ( >>> object_id INTEGER , >>> seq_no INTEGER