[sqlite] [shell] utf-8 bug

2011-12-26 Thread Jens Frederich 
Hi all,

I believe there is a bug in shell tool on Windows. I've tried to store
utf-8 encoded literals in my test db. Do the following to reproduce the
issue:

1. Open a Windows Console (cmd.exe)
2. chcp 65001  # change cmd.exe code page from 437(OEM) to utf-8
3. Run the shell
   > sqlite3.exe test.db
   > create table test(id integer primary key, value text);
   > insert into test (id, value) values (1, 'füchsen'); # literial with
multi byte characters

The shell unexpectantly closed on the last command.

What is the preferred way to save utf-8 encoded literals with the windows
shell tool?

  Jens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] search

2011-12-26 Thread Durga D 
HI all,

   I have sqlite database with more than 1000 records. Here,
residencearea is the primary key.

   for ex:

/country/state/city/village
/country/city
/country/state/city
/country/

country: USA, UK, CHINA


   Here I want to search based on country and sometimes search based on
village and sometimes search based on /country/state/.

   I tried with fts3 and fts4 virtual tables. Not much performance.

   like query on direct table, dead slow.

   Any alternate solution for this?

Thanks in advance.

Regards,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ANN: AnyDAC for Delphi Winter 2012 (v 5.0.5) released

2011-12-26 Thread Dmitry Arefiev 
Dear Sir or Madam,

DA-SOFT Technologies announces the immediate availability of "AnyDAC
for Delphi" v 5.0.5 Winter 2012.

Version Highlights
==
- SQLite v 3.7.9 support;
- major TADTable and Live Data Window mode optimization;
- PostgreSQL v 9 support (named parameters, anonymous blocks, enums);
- Firebird v 3 support (packaged procedures, PSQL functions, identity
columns, BOOLEAN data type);
- Firebird COMPUTED BY support;
- Interbase v 6, 7 support;
- Advantage v 8, 9 support;
- SQL Anywhere v 12 support;
- ElevateDB ODBC support;
- ReportBuilder DADE;
And more. For detailed change log, please, check:
http://www.da-soft.com/anydac/anydac-for-delphi-v-5.0.5.2073-released.html

AnyDAC for Delphi
=
AnyDAC is an unique set of Universal Data Access Components for
developing applications on Delphi, C++Builder and Free Pascal. With
its powerful common architecture AnyDAC enables native high-speed
direct access to SQLite, PostgreSQL, Firebird, MySQL, MS SQL Server,
Oracle, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage Database
and more. For complete list of features and availability, please
check:

* AnyDAC home - http://www.da-soft.com/anydac/
* AnyDAC shop - http://www.da-soft.com/anydac/order.html
* AnyDAC trial - http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

* Native access to SQLite, PostgreSQL, Firebird, MySQL, SQL Server,
Oracle, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and
more. Including latest DBMS versions.
* Generic access to any database supported through dbExpress or ODBC
data sources.
* Optimized for best possible performance. 2 times faster than dbGo,
25% faster than dbExpress.
* Reach API with 50 Delphi VCL components, including TADConnection,
TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
* Unified API for cross-database access, including unified data type
mapping, SQL dialect abstraction, connection aliases.
* First-class support for many database-specific features, including
backup, restore, validation, SQL scripting.
* Advanced Data Access Options, including Array DML, Live Data Window
mode, full Unicode support.
* Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus /
Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
* Perfect integration as back-end driver for TMS AdvGrid, RemObjects
Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases
===
* Desktop - SQLite, Access, Advantage DB, BlackFish SQL, SQL CE.
* Embedded - SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
* Workgroup - PostgreSQL, Firebird, MySQL, SQL Anywhere, Interbase,
Advantage DB.
* Enterprise - Oracle, SQL Server, IBM DB2, Informix.
* Database in clouds - SQL Azure.
* Bridges - dbExpress, ODBC.

Newsletters
===
To subscribe to the newsletter with the AnyDAC release notifications
and other DA-SOFT Technologies product and company news, you can
create an account at DA-SOFT web site, then go to your user profile
and set "Subscribe to newsletter" to "Yes".

Follow us on:
* Twitter - http://www.twitter.com/da_soft
* Facebook - http://www.facebook.com/dasoft
* UserVoice - https://anydac.uservoice.com

--
With best regards,
DA-SOFT Technologies Team
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] why primary key can changed?Id changed is 2, is bug?(UName is unique)

2011-12-26 Thread Kit 
2011/12/25 get bridges :
> create table IF NOT EXISTS Unions
> (
>    Id integer primary key autoincrement,
>    UName nvarchar(500) unique,
>    Filter bit not null default 0
> );
>
> replace into Unions(UName,Filter) values('a','True')--Source Id is 1
> replace into Unions(UName,Filter) values('a','False')//Changed Id is 2
> why primary key can changed?Id changed is 2,is bug?

REPLACE is an alias of INSERT OR REPLACE.
http://www.sqlite.org/lang_replace.html

The record is inserted, then duplicity is deleted. If you want to
update record, use the UPDATE.
-- 
Kit
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] why primary key can changed?Id changed is 2, is bug?(UName is unique)

2011-12-26 Thread get bridges 
create table IF NOT EXISTS Unions
(
Id integer primary key autoincrement,
UName nvarchar(500) unique,
Filter bit not null default 0
);
 
replace into Unions(UName,Filter) values('a','True')--Source Id is 1
replace into Unions(UName,Filter) values('a','False')//Changed Id is 2
why primary key can changed?Id changed is 2,is bug?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-26 Thread Alexey Pechnikov 
Of cource you may report your bug! But I'm not sure about possibility
of the bugfix in upstream and so I speak about patch to SQLite binding
for your language.

-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users