Re: [sqlite] sqlite built as Multithread

Jozef Knotek > > I am struggling with building SQLite as Multithread > (-DSQLITE_THREADSAFE=2). > For various reasons, using -DSQLITE_THREADSAFE=2 with System.Data.SQLite is not recommended. Only -DSQLITE_THREADSAFE=1 should be used with native

Re: [sqlite] [BugReport]Data changes cannot actually flush to disk

Some times writes that have been cached will not be written to disk. In code we use the flush() to insure changes are made. In the OS we need to be sure that the system has been shutdown properly. .02 ends. Sent from my iPhone > On Jun 8, 2016, at 7:20 AM, Simon Slavin

Re: [sqlite] [BugReport]Data changes cannot actually flush to disk

On 7 Jun 2016, at 8:13am, 刘翔 wrote: > Problem: > When update database and power off immediately, How soon do you turn the power off ? Two seconds ? Ten seconds ? One minute ? What type of hard disk do you have ? Is it a rotating disk or a solid state drive ? Is

Re: [sqlite] [BugReport]Data changes cannot actually flush to disk

On 6/7/16, 刘翔 wrote: > Dear SQLite developers, > > Sqlite version: 3.8.8.3 > Linux version: 3.10.31-ltsi > > Problem: > When update database and power off immediately, it cannnot actually make > changes to database file in the disk. > Although the HAVE_FDATASYNC

[sqlite] sqlite built as Multithread

Hi, I am struggling with building SQLite as Multithread (-DSQLITE_THREADSAFE=2). Is there System.Data.SQLite .dll built as Multithread available anywhere please? Or are there any easy to understand steps how to build it? Thanks a lot. Jozef

[sqlite] Maybe A Bug in [fcntlSizeHint] function of SQLite?

In the source code of [fcntlSizeHint] in SQLite 3.9.2, Its comment said that "If the database is already nBytes or larger, this routine is a no-op.”. But if SQLITE_MAX_MMAP_SIZE0, there is no judgement about file size. #if SQLITE_MAX_MMAP_SIZE0 if( pFile-mmapSizeMax0 nBytepFile-mmapSize ){

Re: [sqlite] Latin-1 characters cannot be supported for Unicode

Hi Wei Wang, Did you populate the database from the sqlite3 CLI tool, your own C program, or from another language? Do you see this when you create a database from scratch, if you use a database created by another program, or in both cases? If you populated the database from the sqlite3 CLI

Re: [sqlite] Latin-1 characters cannot be supported for Unicode

Yes, I missed the trailing 00 -Ursprüngliche Nachricht- Von: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Jean-Christophe Deschamps Gesendet: Mittwoch, 08. Juni 2016 09:37 An: SQLite mailing list

Re: [sqlite] Latin-1 characters cannot be supported for Unicode

At 09:22 08/06/2016, you wrote: A 3 Byte Sequence 0xFFFEC4 when converting 0xC4 to UTF-8 in UltraEdit This 3-byte sequence is neither UTF8 or UTF16 even if the BOM would make us believe it is UTF16-LE. UTF16 implies 16-bit encoding units, so an odd byte length is impossible. You probably

Re: [sqlite] Latin-1 characters cannot be supported for Unicode

That the same character is found in both encodings is no surprise. You need to look at the actual sequence of bytes. Comparing a file containing just the "capital A with diaresis" yields A 1 Byte sequence 0xC4 in ANSI A 2 Byte sequence 0xC384 in en_US.UTF8 on a RH5 linux system A 3 Byte