[sqlite] sqlite3_get_table

In previous versions (<=3.4.10) I use to do if (errmsg) { free(errmsg) ; } without problem. In 3.5.6 the free() will segfault (yes, even after if) with a "invalid pointer" message. It's my old understanding that sqlite3_get_table (previously sqlite_get_table) will malloc for *errmsg and I'll

Re: [sqlite] Japanese-Korean characters

The only restriction is to escape \0. I've been storing GB2312, BIG5 and UTF8 Chinese characters since 2.x versions without any problem. Japanese/korean characters should be OK.

Re: [sqlite] sqlite.so for php 4

>can anyone send me sqlite.so for php 4, i can't see http://www.mail-archive.com/sqlite-users@sqlite.org/msg01393.html

[sqlite] sqlite3 error in kexi-0.1beta5

I got this. kexi: btree.c:1043: sqlite3BtreeOpen: Assertion `sizeof(ptr)==sizeof(char*)' failed. KCrash: Application 'kexi' crashing... Can't figure out at this moment as I still work use 2.8.12 in production.

[sqlite] bug in time() ?

I think the time() function is not reporting the correct time. The date part is OK. I also note that CVSTrac uses C codes to handle datetime i.e. not relying on sqlite. Is there a bug? Some investigation ... bash-2.05b$ date Wed Mar 31 11:12:03 HKT 2004 bash-2.05b$ sqlite SQLite version

[sqlite] Re: PHP extention (or sqlite.so)

I have placed a copy of sqlite.so (php 4.2.2 + sqlite 2.8.12) at http://home.graffiti.net/kenlo/sqlite.so Simply placed it in /usr/lib/php4 and load it with dl('sqlite.so') or via php.ini as usual. Compiling sqlite.so for php < 4.3.3 is a bit tricky because of some changes in config.m4 (I