Re: [sqlite] Major projects using SQLite

[Jim Dodgen]

I am using SQLite for a internal project. I has been under heavy use for 
over 18 months. It is a CGI application/web service constructed of 
31,000 lines of PERL and embedded SQL. It has worked flawlessly.  Even 
upgrades (currently 3.3.5) have been pretty smooth.


SQLite rules!

thanks to DRH

Re: [sqlite] how to flush database to disk?

[joe]

On Jul 14, 2006, at 23:43 UTC, Kees Nuyt wrote:

> The syntax descriptions about PRAGMA synchronous= could shed
> some light. http://www.sqlite.org/pragma.html#modify
> Note: The default for the "synchronous" PRAGMA is version
> dependent.

That's interesting.  What is "the F_FULLFSYNC syncing method" (since I am 
running on Mac OS X)?  For what it's worth, PRAGMA FULLFSYNC returns 0 on my 
database.

PRAGMA SYNCHRONOUS returns 2, which should be the safest mode.  I am at a loss.

Best,
- Joe



--
Joe Strout -- [EMAIL PROTECTED]
Verified Express, LLC "Making the Internet a Better Place"
http://www.verex.com/

Re: Re: [sqlite] how to flush database to disk?

[joe]

On Jul 15, 2006, at 00:27 UTC, Will Leshner wrote:

> Since I happen to know this is being done with REALbasic, are you
> calling COMMIT yourself, explicitly, or are you calling the Commit
> method? I suppose there could be a bug in the REALbasic plugin that is
> somehow preventing a commit from happening properly even if you call
> Commit (though I am not aware of such a bug).

I'm using the Commit method.  I can try executing the COMMIT SQL command 
instead.  Though as another poster pointed out, I shouldn't really need to do 
either, since I'm not using BEGIN.

Best,
- Joe

--
Joe Strout -- [EMAIL PROTECTED]
Verified Express, LLC "Making the Internet a Better Place"
http://www.verex.com/

Re: Re: [sqlite] how to flush database to disk?

[Will Leshner]

On 7/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


Yet my observations indicate that the database hadn't written anything to disk 
in two days (or if it had, it somehow decided to roll back the last two days' 
worth after the crash).  Any insight on that?


It really sounds like you've never called COMMIT. I've never heard of
SQLite not writing data to disk as soon as you call COMMIT.

Since I happen to know this is being done with REALbasic, are you
calling COMMIT yourself, explicitly, or are you calling the Commit
method? I suppose there could be a bug in the REALbasic plugin that is
somehow preventing a commit from happening properly even if you call
Commit (though I am not aware of such a bug).

Re: [sqlite] how to flush database to disk?

[joe]

On Jul 14, 2006, at 22:53 UTC, Kees Nuyt wrote:

> How many SQL commands are in your typical transaction?

One.

> Do you start them with a "BEGIN" ?

No, I'm using implicit transactions.

> If you never do a "BEGIN", every SQL command is 
> one transaction, and "COMMIT" has no meaning.

Yes, I'm aware of that, but it shouldn't hurt either (right?).

Yet my observations indicate that the database hadn't written anything to disk 
in two days (or if it had, it somehow decided to roll back the last two days' 
worth after the crash).  Any insight on that?

Best,
- Joe

--
Joe Strout -- [EMAIL PROTECTED]
Verified Express, LLC "Making the Internet a Better Place"
http://www.verex.com/

Re: [sqlite] how to flush database to disk?

[joe]

On Jul 14, 2006, at 22:22 UTC, Will Leshner wrote:

> COMMIT should write the data to disk. Did you check errors after the
> COMMIT to be sure there wasn't some kind of error?

Yes, I checked, no error was ever reported.  Also, I very clearly had all my 
data accessible while the app was running, but after killing and restarting it, 
the last two days' worth was gone.  (Two days is roughly how long it had been 
since the last time I started the app, though I can't be precise about that.)

If it matters, I'm using this in REALbasic, and doing the commit via the 
db.Commit method.  I could try instead doing db.SQLExecute "COMMIT", though I 
would expect these to be equivalent.

Thanks,
- Joe


--
Joe Strout -- [EMAIL PROTECTED]
Verified Express, LLC "Making the Internet a Better Place"
http://www.verex.com/

Re: [sqlite] how to flush database to disk?

[Will Leshner]

On 7/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


It's acting as though all the changes were held in memory, or somehow 
journaled, and when the crash happened, the changes were all lost or rolled 
back.  What I need is a way to force the database to save its data to disk 
while my app is running, so that in the event of a crash, I lose little or no 
data.  How can I do this?  I presume that closing the database would do the 
trick, but is there a less heavy-handed way?


COMMIT should write the data to disk. Did you check errors after the
COMMIT to be sure there wasn't some kind of error?

[sqlite] how to flush database to disk?

[joe]

I've just lost a couple of days' worth of data when my app crashed.  (Well, the 
data wasn't a total loss thanks to backup plans, but the database itself 
essentially reverted to its state of 2 days ago.)  This is despite my app doing 
a COMMIT after every modification of the DB.

It's acting as though all the changes were held in memory, or somehow 
journaled, and when the crash happened, the changes were all lost or rolled 
back.  What I need is a way to force the database to save its data to disk 
while my app is running, so that in the event of a crash, I lose little or no 
data.  How can I do this?  I presume that closing the database would do the 
trick, but is there a less heavy-handed way?

Thanks,
- Joe


--
Joe Strout -- [EMAIL PROTECTED]
Verified Express, LLC "Making the Internet a Better Place"
http://www.verex.com/

[sqlite] Re: Memory exhaust

[Robert Wallner]

I think I found the problem.
I used a version of pysqlite compiled against sqlite3.2.8.
When used with the shared library from any sqlite 3.3.x version, every
sql operation eats all memory.

Thank you all for the help


On 7/14/06, Eduardo <[EMAIL PROTECTED]> wrote:

At 17:43 13/07/2006, you wrote:
>Even the smallest sql statement (like PRAGMA temp_store = 1) triggers
>this behaviour when using sqlite 3.3.x. I forgot to mention that I
>connect to a :memory: database and then attach 2 database to the
>connection.

Perhaps the 2 database attached are converted to :memory: database
also and eat your ram. What size has each one? Try to use the
:memory: database as file database (so no :memory: databases).

I suggest to don't work with :memory: , use a ramdisk. Here you have
a litttle tutorial about doing so
http://www.vanemery.com/Linux/Ramdisk/ramdisk.html . Also, as it's a
ramdisk you can switch off journaling and you can format it with a
filesystem with compression on the fly. As counters, the same as
:memory: databases, when a electrical failure happens, data is lost.
You can trigger a .dump to file easily at fixed times or use more
specialiced ramdisk drivers which do it automatically.

...

>--
>Robert Wallner

-
La diferencia entre la teoria y la practica es que en teoria no hay,
pero en la practica si





--
Robert Wallner

Re: [sqlite] Re: Memory exhaust

[Eduardo]

At 17:43 13/07/2006, you wrote:

Even the smallest sql statement (like PRAGMA temp_store = 1) triggers
this behaviour when using sqlite 3.3.x. I forgot to mention that I
connect to a :memory: database and then attach 2 database to the
connection.


Perhaps the 2 database attached are converted to :memory: database 
also and eat your ram. What size has each one? Try to use the 
:memory: database as file database (so no :memory: databases).


I suggest to don't work with :memory: , use a ramdisk. Here you have 
a litttle tutorial about doing so 
http://www.vanemery.com/Linux/Ramdisk/ramdisk.html . Also, as it's a 
ramdisk you can switch off journaling and you can format it with a 
filesystem with compression on the fly. As counters, the same as 
:memory: databases, when a electrical failure happens, data is lost. 
You can trigger a .dump to file easily at fixed times or use more 
specialiced ramdisk drivers which do it automatically.


...


--
Robert Wallner


-
La diferencia entre la teoria y la practica es que en teoria no hay, 
pero en la practica si 

Re: [sqlite] "no such column" problem with multi level sub queries

[John Cruz]

Thanks Martin for the quick response.

However, that was the original query and that didn't work.  I've even tried 
using alias on that (SELECT error as x. tt.error=x) to no avail.


I did tried setting the statement before to tt.error=error and that yields 
me an output but the value of totalerror for the rest of the output rows are 
always set to the first output (which shouldn't be the case).


Regards,

John



Original Message Follows
From: Martin Jenkins <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] "no such column" problem with multi level sub queries
Date: Fri, 14 Jul 2006 12:46:26 +0100
MIME-Version: 1.0
Received: from sqlite.org ([67.18.92.124]) by bay0-mc2-f13.bay0.hotmail.com 
with Microsoft SMTPSVC(6.0.3790.2444); Fri, 14 Jul 2006 04:48:31 -0700

Received: (qmail 23254 invoked by uid 1000); 14 Jul 2006 11:46:30 -
Received: (qmail 23246 invoked from network); 14 Jul 2006 11:46:28 -
X-Message-Info: LsUYwwHHNt3660MmjhEvYg2f34OAemlKtU9j2Z7TuGo=
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Precedence: bulk
List-Id: SQLite Users Mailing List 
List-Post: 
List-Help: 
List-Unsubscribe: 
List-Subscribe: 
Delivered-To: mailing list sqlite-users@sqlite.org
Organization: XQP Ltd
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
References: <[EMAIL PROTECTED]>
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 14 Jul 2006 11:48:32.0022 (UTC) 
FILETIME=[6E308360:01C6A73B]


No doubt Igor or one of the others will be able to explain *why* your SQL 
fails but changing line 1 from


> 1: SELECT testlog.error,

to

> 1: SELECT error,

works with Python 2.5 using the built-in sqlite (3.3.4) on XP and with 
Python 2.4 and pysqlite (2.8.16) on Debian Sarge.


Martin

John Cruz wrote:

Apologies for the below statement:

Seems the culprit is line 5's testlog.error.  It doesn't seem to see a 3 
level deep SELECT.  Running from line 2.


I was trying to modify the query line and forgot to clean my email.  But 
the statement about "3 level deep" stays.  :-)


Thanks,

John


Hello folks,

Not sure if I'm doing this right or not but...

.. I'm trying to query the total occurence of an error on the last status 
of the unit.  Anyways, my table contains at least these fields: sn (serial 
number), error (error code), testend (test time).


Right now I'm doing this query:

1: SELECT testlog.error,
2:  (
3:  SELECT count(*) FROM
4:(SELECT max(tt.testend) FROM testlog AS tt
5:  WHERE tt.testend LIKE '2006/07/13%'
6:AND tt.error=testlog.error
7:  GROUP BY tt.sn)
8:  )
9:  AS totalerror
10:  FROM testlog WHERE testend LIKE '2006/07/13%'
11:  GROUP by testlog.error;

from which I'm getting this error message...
  "SQL error: no such column: testlog.error"

AW: [sqlite] Major projects using SQLite

[Michael Ruck]

You can add Orb (www.orb.com) to the list.

Mike

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Gesendet: Freitag, 14. Juli 2006 17:04
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Major projects using SQLite

=?iso-8859-1?Q?Jon_Garc=EDa_de_Salazar_Bilbao?= <[EMAIL PROTECTED]> wrote:
> 
> Could you give examples of some major software projects using SQLite?

* Apple OS-X
* Solaris 10
* Firefox
* Monotone
* SymbianOS (used in cellphones)
* YUM
* America Online (AOL)
* PHP
* Philips MP3 players
* POPFile
* Amarok
* Trac
* McAfee Anti-Virus
* SpamSieve
* DSPAM
* Songbird

--
D. Richard Hipp   <[EMAIL PROTECTED]>

Re: [sqlite] Major projects using SQLite

[drh]

=?iso-8859-1?Q?Jon_Garc=EDa_de_Salazar_Bilbao?= <[EMAIL PROTECTED]> wrote:
> 
> Could you give examples of some major software projects using SQLite?

* Apple OS-X
* Solaris 10
* Firefox
* Monotone
* SymbianOS (used in cellphones)
* YUM
* America Online (AOL)
* PHP
* Philips MP3 players
* POPFile
* Amarok
* Trac
* McAfee Anti-Virus
* SpamSieve
* DSPAM
* Songbird

--
D. Richard Hipp   <[EMAIL PROTECTED]>

Re: [sqlite] Major projects using SQLite

[Bill King]

Jon García de Salazar Bilbao wrote:


Hi,
Could you give examples of some major software projects using SQLite?
Thanks, Jon.


Trolltech's qtopia mobile phone platform is using sqlite for pim, 
contacts, and document metainfo.

http://www.trolltech.com/products/qtopia

Re: [sqlite] Major projects using SQLite

[G. Roderick Singleton]

On Fri, 2006-07-14 at 15:16 +0100, Martin Jenkins wrote:
> Jon García de Salazar Bilbao wrote:
> > Hi,
> > Could you give examples of some major software projects using SQLite?
> > Thanks, Jon.
> 
> Solaris 10 - http://blogs.sun.com/roller/page/eric_boutilier/20050405
> 
> Martin

http://fedoraproject.org/wiki/Tools/yum
-- 
G. Roderick Singleton <[EMAIL PROTECTED]>
PATH tech


smime.p7s
Description: S/MIME cryptographic signature

Re: [sqlite] How to port the SQLite

[Christian Smith]

Vivek R uttered:


Hi ,
I am New bee to the group and SQLite. Can anyone explain me How to port the
SQLite to DVD or Consumer products or any other Embedded Systems. Where I
can look for it ? What and all things to be considered while porting. Which
is the best version to port to consumer product which runs VxWorks.



VxWorks comes with a POSIX compliant API, IIRC, so it should be just a 
case of using the existing UNIX based port. Have you tried compiling a 
default release?





Thanks and Regards,
Vivek R



--
/"\
\ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
 X   - AGAINST MS ATTACHMENTS
/ \

Re: [sqlite] Major projects using SQLite

[Craig Morrison]

Jon García de Salazar Bilbao wrote:

Hi,
Could you give examples of some major software projects using SQLite?
Thanks, Jon.


FireFox 2.0..

--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
  Controlling pseudoephedrine purchases.

http://www.mtsprofessional.com/
  A Win32 email server that works for You.

RE: [sqlite] Major projects using SQLite

[James Moore]

Many, many PHP based sites (Including parts of PHP.net itself IIRC)..

http://www.php.net/sqlite 

- James

-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED] 
Sent: 14 July 2006 15:16
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Major projects using SQLite

Jon García de Salazar Bilbao wrote:
> Hi,
> Could you give examples of some major software projects using SQLite?
> Thanks, Jon.

Solaris 10 - http://blogs.sun.com/roller/page/eric_boutilier/20050405

Martin

Re: [sqlite] Major projects using SQLite

[Martin Jenkins]

Jon García de Salazar Bilbao wrote:

Hi,
Could you give examples of some major software projects using SQLite?
Thanks, Jon.


Solaris 10 - http://blogs.sun.com/roller/page/eric_boutilier/20050405

Martin

Re: [sqlite] Major projects using SQLite

[Jay Sprenkle]

On 7/14/06, Jon García de Salazar Bilbao <[EMAIL PROTECTED]> wrote:

Hi,
Could you give examples of some major software projects using SQLite?


I created an events management website for a local convention.
sqlite was used for the storage and management of all the events at
the convention.

[sqlite] Major projects using SQLite

[Jon García de Salazar Bilbao]

Hi,
Could you give examples of some major software projects using SQLite?
Thanks, Jon. 


- PLEASE NOTE 
---
This message, along with any attachments, may be confidential or legally privileged. 
It is intended only for the named person(s), who is/are the only authorized recipients.

If this message has reached you in error, kindly destroy it without review and 
notify the sender immediately.
Thank you for your help.
µSysCom uses virus scanning software but excludes any liability for viruses 
contained in any attachment.

 ROGAMOS LEA ESTE TEXTO 
---
Este mensaje y sus anexos pueden contener información confidencial y/o con derecho legal. 
Está dirigido únicamente a la/s persona/s o entidad/es reseñadas como único destinatario autorizado.
Si este mensaje le hubiera llegado por error, por favor elimínelo sin revisarlo ni reenviarlo y notifíquelo inmediatamente al remitente. Gracias por su colaboración.  
µSysCom utiliza software antivirus, pero no se hace responsable de los virus contenidos en los ficheros anexos.

Re: [sqlite] Re: Memory exhaust

[Martin Jenkins]

Robert Wallner wrote:

Even the smallest sql statement (like PRAGMA temp_store = 1) triggers
this behaviour when using sqlite 3.3.x. I forgot to mention that I
connect to a :memory: database and then attach 2 database to the
connection.


I've been using the apsw and pysqlite wrappers for some time now and
haven't seen this problem. After running the PythonWin sessions below
(on XP) memory usage (in both cases) is under 10MB.

On Debian Sarge running a similar python session (sqlite 2.8.16 though) 
and a sqlite 3.2.1 session on the memory usage in both cases is under 5MB.


Have you a smallish test case?

Martin

PythonWin 2.4.3 (#69, Mar 29 2006, 17:35:34) [MSC v.1310 32 bit (Intel)]
on win32.
Portions Copyright 1994-2004 Mark Hammond ([EMAIL PROTECTED]) -
see 'Help/About PythonWin' for further copyright information.

from pysqlite2 import dbapi2 as sqlite3
CM=sqlite3.connect(":memory:")
C1=sqlite3.connect("db1")
C2=sqlite3.connect("db2")
C1.execute("create table t1(i INTEGER, t TEXT)")



C2.execute("create table t2(i INTEGER, t TEXT)")



CM.execute("create table tm(i INTEGER, t TEXT)")



CM.execute("attach database db1 as db1")



CM.execute("attach database db2 as db2")



CM.execute("insert into tm values(1,'one')")



sqlite3.version, sqlite3.sqlite_version

('2.2.1', '3.3.5')




PythonWin 2.5b2 (r25b2:50512, Jul 11 2006, 10:16:14) [MSC v.1310 32 bit
(Intel)] on win32.
Portions Copyright 1994-2004 Mark Hammond ([EMAIL PROTECTED]) -
see 'Help/About PythonWin' for further copyright information.

import sqlite3
CM=sqlite3.connect(":memory:")
C1=sqlite3.connect("db1")
C2=sqlite3.connect("db2")
C1.execute("create table t1(i INTEGER, t TEXT)")



C2.execute("create table t2(i INTEGER, t TEXT)")



CM.execute("create table tm(i INTEGER, t TEXT)")



CM.execute("attach database db1 as db1")



CM.execute("attach database db2 as db2")



CM.execute("insert into tm values(1,'one')")



sqlite3.version, sqlite3.sqlite_version

('2.3.2', '3.3.4')




[EMAIL PROTECTED]:~$ python2.4
Python 2.4.1 (#2, May  5 2005, 11:32:06)
[GCC 3.3.5 (Debian 1:3.3.5-12)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite
>>> CM=sqlite.connect(":memory:")
>>> C1=sqlite.connect("db1")
>>> C2=sqlite.connect("db2")
>>> cm=CM.cursor()
>>> c1=C1.cursor()
>>> c2=C2.cursor()
>>> cm.execute("create table tm(i INTEGER, t TEXT)")
>>> c1.execute("create table t1(i INTEGER, t TEXT)")
>>> c2.execute("create table t2(i INTEGER, t TEXT)")
>>> C1.commit()
>>> C2.commit()
>>> C1.close()
>>> C2.close()
>>> cm.execute("attach database db1 as db1")
>>> cm.execute("attach database db2 as db2")
>>> cm.execute("insert into tm values(1,'one')")
>>> cm.execute("select * from tm")
>>> cm.fetchall()
[(1, 'one')]
>>> sqlite.version, sqlite._sqlite.sqlite_version()
('1.0.1', '2.8.16')
>>>

Re: [sqlite] "no such column" problem with multi level sub queries

[Martin Jenkins]

No doubt Igor or one of the others will be able to explain *why* your 
SQL fails but changing line 1 from


> 1: SELECT testlog.error,

to

> 1: SELECT error,

works with Python 2.5 using the built-in sqlite (3.3.4) on XP and with 
Python 2.4 and pysqlite (2.8.16) on Debian Sarge.


Martin

John Cruz wrote:

Apologies for the below statement:

Seems the culprit is line 5's testlog.error.  It doesn't seem to see a 3 
level deep SELECT.  Running from line 2.


I was trying to modify the query line and forgot to clean my email.  But 
the statement about "3 level deep" stays.  :-)


Thanks,

John


Hello folks,

Not sure if I'm doing this right or not but...

.. I'm trying to query the total occurence of an error on the last 
status of the unit.  Anyways, my table contains at least these fields: 
sn (serial number), error (error code), testend (test time).


Right now I'm doing this query:

1: SELECT testlog.error,
2:  (
3:  SELECT count(*) FROM
4:(SELECT max(tt.testend) FROM testlog AS tt
5:  WHERE tt.testend LIKE '2006/07/13%'
6:AND tt.error=testlog.error
7:  GROUP BY tt.sn)
8:  )
9:  AS totalerror
10:  FROM testlog WHERE testend LIKE '2006/07/13%'
11:  GROUP by testlog.error;

from which I'm getting this error message...
  "SQL error: no such column: testlog.error"

Re: [sqlite] sqlite3_column_text question

[drh]

"Alexei Alexandrov" <[EMAIL PROTECTED]> wrote:
> Still I can't understand why sqlite3_column_text returns (unsigned
> char *), but sqlite3_bind_text takes (const char *). What am I
> missing?
> 

Why does signed vs. unsigned char matter to you?

Perhaps the interface could be more consistent.  But
the policy with SQLite is to never change the interface
in order to provide backwards compatibility.  So you
will just have to live with the interface as it stands.
Or else fork the code and make your own incompatible
version...
--
D. Richard Hipp   <[EMAIL PROTECTED]>

Re: [sqlite] Searching for the sqlite3 struct to use with asm

[drh]

[EMAIL PROTECTED] wrote:
> Hi at all, I wanna use sqlite3 with masm but i could not found the
> sqlite3 struct. I only found typedef struct sqlite3 sqlite3; in
> sqlit3.h. Can someone help me?

struct sqlite3 is an opaque structure.  Treat it like a void*.
--
D. Richard Hipp   <[EMAIL PROTECTED]>

Re: [sqlite] SQL Like expr not case sensitive Bug

[drh]

Pasquale Imbemba <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> is there any news about when this bug (read:
> http://www.sqlite.org/lang_expr.html) will be fixed?
> 

It isn't a bug.  That is the way LIKE works.  But you
can change the behavior using:

  PRAGMA case_sensitive_like=ON;


--
D. Richard Hipp   <[EMAIL PROTECTED]>

Re: [sqlite] sqlite3_column_text question

[Alexei Alexandrov]

Still I can't understand why sqlite3_column_text returns (unsigned
char *), but sqlite3_bind_text takes (const char *). What am I
missing?

On 6/30/06, Alexei Alexandrov <[EMAIL PROTECTED]> wrote:

>
> Perhaps because it is returning UTF8 and that needs to be unsigned, not 
signed?
>

Hmm, why sqlite3_bind_text takes const char * then?

--
Alexei Alexandrov




--
Alexei Alexandrov

[sqlite] Searching for the sqlite3 struct to use with asm

[cusdom]

Hi at all, I wanna use sqlite3 with masm but i could not found the
sqlite3 struct. I only found typedef struct sqlite3 sqlite3; in
sqlit3.h. Can someone help me?
Greetings, cusDom

[sqlite] How to port the SQLite

[Vivek R]

Hi ,
I am New bee to the group and SQLite. Can anyone explain me How to port the
SQLite to DVD or Consumer products or any other Embedded Systems. Where I
can look for it ? What and all things to be considered while porting. Which
is the best version to port to consumer product which runs VxWorks.

Thanks and Regards,
 Vivek R

[sqlite] SQL Like expr not case sensitive Bug

[Pasquale Imbemba]

Hi,

is there any news about when this bug (read:
http://www.sqlite.org/lang_expr.html) will be fixed?

Cheers
Pasquale

[sqlite] Re: Which is most appropriate encoding ?

[Hussain KH]

Which is the best encoding for Indic Scripts? For Malayalam?
If UTF16, then what is the specification for defining a text field?
I use Windows XP with Service Pack2; SQLite336, SQLitedll336 and SQLiteODBC68

Regards, Hussain

On 6/28/06, RohitPatel <[EMAIL PROTECTED]> wrote:


> FWIW, if Windows is your only target, UTF-16 is the best choice for
> you, because wchar_t is in UTF-16 on Windows and you can avoid some
> string conversion in this case, while still be able to enable the
> stuff for other OSes as soon as there is a need for it.
>
> Alexei Alexandrov

I think wchar_t will not work on Windows 98. (I do not want to use MS
Unicode layer on Windows98).
I need my app to work on Windows 98 also.

Rohit

--
View this message in context:
http://www.nabble.com/Which-is-most-appropriate-encoding---tf1780532.html#a5081544
Sent from the SQLite forum at Nabble.com.