[sqlite] [shell] utf-8 bug

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

[sqlite] search

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

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

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 b

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

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

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

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 primar

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

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