On 7/30/07, wcmadness [EMAIL PROTECTED] wrote:
I'm stuck on this. I'm writing a data layer that potentially needs to handle
diacritical (sp?) characters, such a French accented é characters or German
umlauted characters (sp?). It should be rare that I would run into
something like this, but
On 7/30/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
hello, I port the sqlite3 to linux(file system is jffs2).now , I must cout
the nandflash expire in sqlite3 running.
SQLite works on top of the file system, so it has no knowledge of what
JFFS2 and MTD are doing to manage your NAND flash.
I've read a few places that it is not possible to change the encoding
of a database once it's created. Is it possible to do it in some
automated way with any of the command line utilities?
I converted a database from SQLite 2.X to 3.X using sqlite.exe's .dump
function and apparently didn't set
On 7/30/07, Mitchell Vincent [EMAIL PROTECTED] wrote:
I've read a few places that it is not possible to change the encoding
of a database once it's created. Is it possible to do it in some
automated way with any of the command line utilities?
Read about the pragma encoding [1] SQL command (you
What would be a good strategy in adding indexes to the various tables?
I know SQLite can only use one index in simple (not intersect etc.) queries,
so is it usually best to make:
- indexes that include all possible combinations of fields that may appear
in a WHERE clause.
- make one very large
Right now, when i do a select in sqlite that is supposed to be in
alphabetical order, i get:
DC
Da
De
Do
instead of:
Da
DC
De
Do
The LIKE operator doesn't seems to be helping me here either. It
searches the text case-insensitively, but it still outputs it in the
wrong order. Keep in
Thanks James,
But everything is still foggy to me. Could you show me some example
syntax that accomplishes the following.
Thanks again,
Rahul.
James Dennett wrote:
-Original Message-
From: Rahul Banerjee [mailto:[EMAIL PROTECTED]
Sent: Friday, July 27, 2007 1:34 PM
To:
It is in correct order. You might try COLLATE NOCASE to force an uper
case only sort.
Chase wrote:
Right now, when i do a select in sqlite that is supposed to be in
alphabetical order, i get:
DC
Da
De
Do
instead of:
Da
DC
De
Do
The LIKE operator doesn't seems to be helping me here
ok. here's a SELECT that works...
SELECT foo FROM bar WHERE foo LIKE 'D%' ORDER BY upper(foo);
but, how could that upper(foo) part be used with the CREATE INDEX syntax?
neither of the following attemps worked (syntax errors):
CREATE INDEX barfooindex ON bar upper(foo);
or
CREATE INDEX
John Stanton [EMAIL PROTECTED] wrote:
You should take a closer look at the structure of Sqlite, in
particular how it uses pages. It is not amenable to your row locking
strategy.
Optimistic locking doesn't lock anything per se. It's a
download-modify-upload cycle where the upload part checks
Hi RBS,
- indexes that include all possible combinations of fields that may
appear
in a WHERE clause.
As an aside, note that, AFAIK, indexes are only used:
1. To get the first match of a query. If you ask for more than one
matching record, the second, third etc matches are found by
Lower case and upper case are different, with lower case having the
higher vlaue. To get case insensitive sorts do this:
CREATE TABLE mytab (a TEXT COLLATE NOCASE);
then
SELECT a FROM mytab ODRER BY a; will give a case insensitive sorted list.
Chase wrote:
ok. here's a SELECT that
Hello,
I'd been looking into a bug in my
application which worked down to
an issue with Bitwise AND and
bound variables in prepared
statements it seems.
The query...
SELECT *
FROM example
WHERE (intColumn 4294901760) = ?
Where 'intColumn' is an integer
column and the parameter is
bound using
Tank you very much, I know that all of the sqlite's operates will be parsed
to vdbe code, but i don't know
how can i get the map of vdbe code to file operate.
Ben Combee wrote:
On 7/30/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
hello, I port the sqlite3 to linux(file system is
Gilles Ganault gilles.ganault-jG/[EMAIL PROTECTED]
wrote:
I'd like to use a timestamp column in each table to keep track of
when a column was last updated, so that a user can be notified of a
problem
when trying to updated a record that has already been updated by
another
user while the first
Hi Tom,
I have one more query regarding usage of indexes.
2. From left to right in the same order as your index. So if you
create index MyIndex on MyTable ( Column1, Column2, Column3 ), then
you must test them in the same order, eg: where Column1 = Value1 and
Column2 = Value2 or Column3 =
At 23:20 30/07/2007 -0400, Igor Tandetnik wrote:
http://sqlite.org/capi3ref.html#sqlite3_changes
Makes sense. Thanks!
-
To unsubscribe, send email to [EMAIL PROTECTED]
17 matches
Mail list logo