[sqlite] Re: ! [sqlite] batch mode for sqlite? How to quit?

ooOoo <[EMAIL PROTECTED]> writes: > Is there a way to force sqlite to quit when it reads > commands from a file? > > Here is what I have in mind: > > For a file junk.in: > > begin transaction; > insert into students values( > 6588,'Ezak','Dood','F2001'); > commit; > > I

[sqlite] libtclsqlite3.so

How do I build libtclsqlite3.so? The generated Makefile (on GNU/Linux) seems to have no targets for this. In general the tcl stuff seems suboptimal---tclsqlite3 seems to want to build against static versions of the tcl library, but who builds tcl statically?

[sqlite] Sqlite 3.0.2 with LCC for Windows

Hi ! I use LCC-Win32 (http://www.cs.virginia.edu/~lcc-win32/) and I got this Warnings with sqlite 3.0.2 : Warning c:\sqlite3\vdbemem.c: 606 Comparison of signed with unsigned integer Warning c:\sqlite3\vdbemem.c: 647 old-style function definition for 'sqlite3ValueNew' Warning

Re: [sqlite] case (in)sensitiveness in LIKE operator v2 and 3

Thank you Daniel, That will help. Do you know if it is planned that the lookup tables are planned to be added any soon to the source at least as an option to have the sqlite compiled with them. BTW are you aware if there is already someone working on this? Regards - Original Message

Re: [sqlite] case (in)sensitiveness in LIKE operator v2 and 3

SQLite's understanding of upper/lower case characters only extends to the 26 that feature in English. This is to avoid including the huge lookup tables required to provide case insensitive matches across the whole range of unicode characters. You can write a user-function that will be called in

[sqlite] case (in)sensitiveness in LIKE operator v2 and 3

Hello, I am using SQLite with cyrillic letters (e.g. russian) in the DB. I need to perform searches (LIKE operator) I want to have case-INsensitve search in the LIKE operator. I think this is not the case now due to the bug in the LIKE...but I couldn't find any info on the subject? Can anyone

[sqlite] SQLite and PHP 4.3 in windows

hello i want to use php_sqlite.dll in php 4.3, i make this : - i'm working in Win XP pro with IIS - put the php_sqlite.dll in c:\php - edit the php.ini, i change the "extension_dir" to c:\php - restart the iis but when i load a page with sqlite i've an error can load module php_sqlite.dll...