RE: [sqlite] Wildcards in LIKE

Ok, just found it - sorry... But this does raise a question, I have UNICODE data, but it says that LIKE only works correctly (i.e. case-insensitive) on 7-bit data. Can someone tell me please how to make it work correctly for UNICODE as well then? As I read from the docs there, I have to override

[sqlite] Wildcards in LIKE

Hello, Does SQLite v3 support wildcards in the LIKE statement and if yes, how do I express them? (sorry didn't find any info in the docs on this) TIA Dennis // Software for animal shelters http://www.smartpethealth.com //

[sqlite] SQL commands

I am considering switching over to SQLite from MySQL. Before I take the plunge, could someone give me the heads up on whether any of the following commands are applicable in SQLite? (I couldn't tell from the documentation): 1. REPAIR TABLE tableName EXTENDED 2. SELECT DATE_FORMAT(dateColumn, '%m

Re: [sqlite] in memory databases

Jérôme VERITE, dando pulos de alegria, escreveu : I use Sqlite with file databases and I’m wondering if it is possible to load the totality of this db in memory to perform requests. I saw I can specify :memory: for the filename but by this way, I can’t laod my file database in memory. So the questi

[sqlite] in memory databases

I use Sqlite with file databases and I’m wondering if it is possible to load the totality of this db in memory to perform requests. I saw I can specify :memory: for the filename but by this way, I can’t laod my file database in memory. So the question is very simple How can I load the totality

Re: [sqlite] Sqlite Analyzer

Drew, Stephen wrote: I attempted to open a 2.8.13 database (double the standard page size) with the Sqlite Analyzer. I now get the following error upon opening the DB in the standard fashion: malformed database schema - near "(" Surely if the DB file is unreadable, it shouldn't actually alte

[sqlite] Sqlite Analyzer

I attempted to open a 2.8.13 database (double the standard page size) with the Sqlite Analyzer.  I now get the following error upon opening the DB in the standard fashion:   malformed database schema - near "("   Surely if the DB file is unreadable, it shouldn't actually alter it in anyway?

Re: [sqlite] sqlite_compile - bad return code

Ionut Filip wrote: sqlite_compile returns SQLITE_OK, but *ppVm is NULL and pzErrmsg is "out of memory". What does version 2.8.15 do? -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] SQLite Database File Size

[EMAIL PROTECTED] wrote: Hi, I have started to use SQLite recently. I have an interesting situation of deciding the database schematic for my solution. In one of the tables I need to store contents of size 2000 * 20. If I could create 4 rows containing only one or two columns, my schema is q