[sqlite] codepages

dear users I use sqlite for vb6, utf-8 database, when insert arabic data to database and search it with 'like' operator (within % syntax), return all records!!! Please help me... thanks John Smith ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite not performing a certain update

On 24/01/2009 5:09 AM, Onion Knight wrote: > "UPDATE tags SET lft = CASE WHEN lft BETWEEN ? AND ?" > " THEN lft + ? ELSE lft + ?" > "END WHERE lft BETWEEN ? AND ?", Two suggestions: (A) Check to see if the corresponding SELECT works: "SELECT *, CASE WHEN lft BETWEEN ?

Re: [sqlite] Is this a bug?

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of J. R. Westmoreland Is there a way to get an autoincrement field without being a primary key? Yes, you can create a trigger to do this. (This also allows you great

Re: [sqlite] Is this a bug?

Is there a way to get an autoincrement field without being a primary key? J. R. Westmoreland E-mail: j...@jrw.org -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Friday, January 23,

Re: [sqlite] How many tables can a database hold?

> Can someone tell me how many tables a given database can hold. Try here: http://www.sqlite.org/limits.html > I'm looking at an initial design of an application that could have a table > of data for each city in a state. This could be possibly more than a > thousand tables. Is the data stored

[sqlite] A alternative design question

I'm working on a design for a database that has as its goals two things. First, speed and second, size. The database will be deployed to a hand held device so memory/storage size is an issue. When doing a select something like one of the following two cases which would be faster? 1.

Re: [sqlite] How many tables can a database hold?

J.R, --I'd suggest you check out URL: http://www.sqlite.org/limits.html --joins are typically limited to 64 tables --Assuming you (CAN) define a database with >1000 tables, IMHO, this is a fairly unconventional design strategy, if rarely needed -- some would say this is inadvisable. Typically

Re: [sqlite] Is this a bug?

J. R. Westmoreland wrote: > I have the following table creation statements and get an error. > > Functioning statement > > CREATE TABLE xxx (ID INTEGERPRIMARY KEY AUTOINCREMENT, .) > > If I remove the PRIMARY KEY" part of the statement, according to the > docs on SQL that should be

Re: [sqlite] Is this a bug?

On Fri, Jan 23, 2009 at 12:51:07PM -0700, J. R. Westmoreland scratched on the wall: > I have the following table creation statements and get an error. > > Functioning statement > CREATE TABLE xxx (ID INTEGERPRIMARY KEY AUTOINCREMENT, .) > If I remove the PRIMARY KEY" part of the statement,

[sqlite] Is this a bug?

I have the following table creation statements and get an error. Scenario: Functioning statement CREATE TABLE xxx (ID INTEGERPRIMARY KEY AUTOINCREMENT, .) If I remove the PRIMARY KEY" part of the statement, according to the docs on SQL that should be still a valid statement, I get an

Re: [sqlite] What is the advantage of using native c API over ODBC

You avoid an unecessary layer of software and have better control over the database. goldy wrote: > Hi All, > > What are the basic advantage of using SQLite with C API over ODBC. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >

Re: [sqlite] SQLite not performing a certain update

On Fri, Jan 23, 2009 at 7:24 PM, Igor Tandetnik wrote: > Do you, by any chance, start a transaction and then forget to commit it? > > Igor Tandetnik No, transactions and concurrency is something I'm going to add later, when I've got everything in a working state.

Re: [sqlite] SQLite not performing a certain update

Onion Knight wrote: > I have implemented functionality for adding, removing and renaming > entries in C. When I got to implementing the function for changing the > parent of an entry the SQL UPDATE-statements just aren't being > performed. Do you, by any chance, start a

[sqlite] SQLite not performing a certain update

I have a table representing a hierarchy using the nested set model, declared as CREATE TABLE tags ( id INTEGER PRIMARY KEY AUTOINCREMENT, label TEXT NOT NULL UNIQUE, lft INTEGER NOT NULL, rgt INTEGER NOT NULL ); I have implemented functionality for adding,

Re: [sqlite] JDBC and sqllite 1.1

On Fri, 23 Jan 2009 00:26:00 -0800 (PST), Alessandro Corti wrote in General Discussion of SQLite Database : >The last version of the jdbc is unable to connect >to my old sqlite 1.1 db. >I'm looking for a jdbc driver for sqlite 1.1. Are you sure

Re: [sqlite] Very slow query execution with SQLite Database

manohar s schrieb: > I have a SQLite database which is of size 1.5 GB. The problem that it is > taking a lot of time (12 seconds after execution of vacuum) to execute a * > SELECT* query. > > Query : > SELECT metric_id, MAX(timestamp_id) AS timestamp_id_max FROM > snapshot_master GROUP BY

Re: [sqlite] Very slow query execution with SQLite Database

On Jan 23, 2009, at 11:50 AM, manohar s wrote: > I have a SQLite database which is of size 1.5 GB. The problem that > it is > taking a lot of time (12 seconds after execution of vacuum) to > execute a * > SELECT* query. > > Here is the create Table statement: > CREATE TABLE IF NOT EXISTS

[sqlite] Very slow query execution with SQLite Database

I have a SQLite database which is of size 1.5 GB. The problem that it is taking a lot of time (12 seconds after execution of vacuum) to execute a * SELECT* query. Here is the create Table statement: CREATE TABLE IF NOT EXISTS [snapshot_master] (

[sqlite] Adding Custom Column Data Types

Hello all, I am in the process of integrating SQLite into a multimedia environment/programming language. One thing that I would like to be able to do is support all the various datatypes in this language, and one in particular is a list of other primitive datatypes. Is there a way to add a

[sqlite] Progress update while Prepare() is executing

I am using sqlite3_prepare_v2() to process my SQl queries. This takes around 80% of the processing time compared to recovering the result set. Once the querire has been processed i can obviously provide a progress bar when stepping through the result set, but what progress indication is

Re: [sqlite] Ticket #3602

On Jan 23, 2009, at 5:37 PM, Jens Miltner wrote: > Hi, > > I filed ticket #3602 a couple of days ago: > > Essentially, when using empty test sets ("IN ()" / "NOT IN ()") in the > WHERE expression of a query, an assert() fires inside the bestIndex > function. The assert expects pExpr->pList to be

[sqlite] Ticket #3602

Hi, I filed ticket #3602 a couple of days ago: Essentially, when using empty test sets ("IN ()" / "NOT IN ()") in the WHERE expression of a query, an assert() fires inside the bestIndex function. The assert expects pExpr->pList to be non-NULL and the code actually checks for this to be

Re: [sqlite] Leading/trailing whitespace overrides Numeric type affinity - workarounds ?

Roger Binns writes: > > > MikeW wrote: > > I guess one approach would be to compile with SQLITE_ENABLE_COLUMN_METADATA > > and then to read the column type from there rather than from > > sqlite3_column_type(). > > Or just call sqlite3_column_decltype - >

Re: [sqlite] What is the advantage of using native c API over ODBC

> Hi All, > What are the basic advantage of using SQLite with C API over ODBC. 1. Better Performance. 2. You can use SQLite Features that are not "mappable" to the ODBC-API. 3. You don't have to worry if there are Bugs in the ODBC-Driver. 4. No need to install the ODBC-Driver to let your

[sqlite] JDBC and sqllite 1.1

The last version of the jdbc is unable to connect to my old sqllite 1.1 db. I'm looking for a jdbc driver for sqllite 1.1. Where can I find it? Best regards, Garp ___ sqlite-users mailing list sqlite-users@sqlite.org