Re: [sqlite] National characters in database names on linux

2012-04-20 Thread Darren Duncan
Jānis wrote: I am using library management software Calibre having SQlite as dbms and found that at least on linux I can not give the names to my "shelves" using national characters like ā, ē, ī, š, ķ etc. I was informed by the developer of Calibre that it is limitation introduced by SQLite on

[sqlite] National characters in database names on linux

2012-04-20 Thread Jānis
Hi! I am using library management software Calibre having SQlite as dbms and found that at least on linux I can not give the names to my "shelves" using national characters like ā, ē, ī, š, ķ etc. I was informed by the developer of Calibre that it is limitation introduced by SQLite on lin

Re: [sqlite] Is database corruption possible when writing from multiple processes?

2012-04-20 Thread Richard Hipp
On Fri, Apr 20, 2012 at 12:00 PM, George wrote: > On 4/20/12, Richard Hipp wrote: > > On Fri, Apr 20, 2012 at 10:38 AM, George wrote: > > > >> The webpage [1] mentions that if the sqlite library is linked twice > >> into the same application there is the possibility that the database > >> will

Re: [sqlite] Suggestion about hard-coded time string format YYYY-MM-DD

2012-04-20 Thread Yves Goergen
On 02.04.2012 18:38 CE(S)T, Alexey Pechnikov wrote: > Why we can't control this? As example, in Russia the date format is > DD.MM. and is needed the patch > http://sqlite.mobigroup.ru/fdiff?v1=288ad2e1e017565c&v2=720cb1015e95af7a > > I think the new pragmas DATEFORMAT and TIMEFORMAT will be he

Re: [sqlite] Is database corruption possible when writing from multiple processes?

2012-04-20 Thread George
On 4/20/12, Richard Hipp wrote: > On Fri, Apr 20, 2012 at 10:38 AM, George wrote: > >> The webpage [1] mentions that if the sqlite library is linked twice >> into the same application there is the possibility that the database >> will be corrupted. >> >> Is this also possible when two different p

Re: [sqlite] Is database corruption possible when writing from multiple processes?

2012-04-20 Thread Richard Hipp
On Fri, Apr 20, 2012 at 10:38 AM, George wrote: > The webpage [1] mentions that if the sqlite library is linked twice > into the same application there is the possibility that the database > will be corrupted. > > Is this also possible when two different processes (each of which has > only linked

[sqlite] Is database corruption possible when writing from multiple processes?

2012-04-20 Thread George
The webpage [1] mentions that if the sqlite library is linked twice into the same application there is the possibility that the database will be corrupted. Is this also possible when two different processes (each of which has only linked the library once) are accessing the same database? If not, h

Re: [sqlite] help:database disk image is malformed

2012-04-20 Thread Richard Hipp
On Fri, Apr 20, 2012 at 2:06 AM, wjzhhr wjzhhr wrote: > help:database disk image is malformed > Hi, sqlite team: > Do you know "database disk image is malformed" how to happen??? > http://www.sqlite.org/howtocorrupt.html > I use sqlite3 as my web database, but today, it says "database dis

[sqlite] help:database disk image is malformed

2012-04-20 Thread wjzhhr wjzhhr
help:database disk image is malformed Hi, sqlite team: Do you know "database disk image is malformed" how to happen??? I use sqlite3 as my web database, but today, it says "database disk image is malformed" and I can't open my website. my localhost web site environment:xpsp3+apache2.2.21+

Re: [sqlite] Why does the WinRT code use a new define instead of existing?

2012-04-20 Thread Richard Hipp
On Fri, Apr 20, 2012 at 6:37 AM, Philipp Kursawe wrote: > Hello, > > I wonder why there was a new define introduced for wrapping Windows 8 WinRT > code parts? SQLite uses SQLITE_OS_WINRT. > But the VC compiler already defines _WINRT_DLL for WinRT DLL projects or > "WINAPI_FAMILY=WINAPI_FAMILY_APP"

Re: [sqlite] "DEFAULT BOOLEAN NOT NULL" not working with entityframework

2012-04-20 Thread Black, Michael (IS)
I should have said everybody (and I meant the languages and silicon) is effectively checking "!= 0" for true. And the !!condition is a mathematical theorem of why -1 is not a good value to use for "true"not that you see that very often (if at all). What you do see is "if (!condition == tru

[sqlite] Why does the WinRT code use a new define instead of existing?

2012-04-20 Thread Philipp Kursawe
Hello, I wonder why there was a new define introduced for wrapping Windows 8 WinRT code parts? SQLite uses SQLITE_OS_WINRT. But the VC compiler already defines _WINRT_DLL for WinRT DLL projects or "WINAPI_FAMILY=WINAPI_FAMILY_APP" in general if you compile with the Metro compiler setting. What's