Re: [sqlite] sqlite3 db open/close

Thank you. On Sun, Nov 18, 2012 at 8:18 PM, Yuriy Kaminskiy wrote: > Durga D wrote: > >What happens if sqlite3_close() called multiple times but > > sqlite3_open_v2() called only once. > > > > Practically I dint see any malfunction/corruption here. I would like > to >

Re: [sqlite] light weight write barriers

Vladislav Bolkhovitin, on 11/17/2012 12:02 AM wrote: The easiest way to implement this fsync would involve three things: 1. Schedule writes for all dirty pages in the fs cache that belong to the affected file, wait for the device to report success, issue a cache flush to the device (or request

Re: [sqlite] Which classes of nested requests are not expressible as joins?

Thanks for your answer. I'd like to know to what extent I can convert a Sqlite schema to a Mysql one, but I find the question interesting for itself. What if we forget about modifying commands and care only about retrieval? Clemens Ladisch wrote: I wonder why you want to know this? Well,

Re: [sqlite] SQLite converts all unicode characters into ANSI

On 19 Nov 2012 at 01:57, ZikO wrote: > The script looks like this: > CREATE TABLE IF NOT EXISTS imiona ( > id INTEGER PRIMARY KEY, > data TEXT, > imie1 TEXT, > imie2 TEXT, > imie3 TEXT); > > INSERT INTO imiona (data,imie1,imie2,imie3) VALUES >

[sqlite] malformed database schema

Hello, I'm using ADO.NET-Provider for SQLite (System.Data.SQLite, Version 1.0.80). My database is password-protected. The password is passed in the connection string. Sporadically, I get the following exception: Exception: The database disk image is malformed malformed database schema (VALUE1)

Re: [sqlite] SQLite converts all unicode characters into ANSI

On 19 Nov 2012, at 1:57am, ZikO wrote: > The script was written in Notepad++ > that controls which charset coding is used but I also double checked it in > Notepad and it indicated UTF-8; it can also be confirmed by reading the > script text file in Hex editor that shows BOM at the

Re: [sqlite] SQLite converts all unicode characters into ANSI

ZikO wrote: > INSERT INTO imiona (data,imie1,imie2,imie3) VALUES > ('01/01/2012','Masława','Mieczysława','Mieszka'), > > As you can see, it contains accents. The script was written in Notepad++ > that controls which charset coding is used but I also double checked it in > Notepad and it indicated

Re: [sqlite] SQLite converts all unicode characters into ANSI

ZikO wrote: > I then used the conding UTF-8 without BOM and the command was accepted but > unfortunately I get the strange result: > sqlite> select * from imiona; > 1 01/01/2012 MasławaMieczysława Mieszka This looks like correct UTF-8, it's

Re: [sqlite] SQLite converts all unicode characters into ANSI

On Sun, Nov 18, 2012 at 8:57 PM, ZikO wrote: > Hello, > thanks for your answers. > > I downloaded both precompiled binaries and shell for windows from > www.sqlite.org. > > The script looks like this: > CREATE TABLE IF NOT EXISTS imiona ( > id INTEGER PRIMARY KEY, >

Re: [sqlite] SQLite converts all unicode characters into ANSI

Hello, thanks for your answers. I downloaded both precompiled binaries and shell for windows from www.sqlite.org. The script looks like this: CREATE TABLE IF NOT EXISTS imiona ( id INTEGER PRIMARY KEY, data TEXT, imie1 TEXT, imie2 TEXT, imie3 TEXT);

Re: [sqlite] Which classes of nested requests are not expressible as joins?

emilbarton wrote: > I wonder which classes of nested SQL requests are not expressible as joins? I wonder why you want to know this? Well, anything where you cannot use joins in the first place, such as UPDATE/DELETE commands: DELETE FROM question WHERE type_id IN (SELECT id

[sqlite] Which classes of nested requests are not expressible as joins?

Hello, I wonder which classes of nested SQL requests are not expressible as joins? Could you answer in non-jargon with examples please? Thank you in advance (and thank you for Sqlite by the way!). ___ sqlite-users mailing list sqlite-users@sqlite.org