>
> Irony aside, you wouldn't believe how many systems claiming to be i18n
> aware fail miserably when handling other than Latin-1 charsets
> (especially in filenames).
>
> If Costas can provide a patch, I think it'd be a useful addition to
> the SQLite's Win32 file handling. I'm not sure that
>
> Our Sqlite applications work not only on Win98 and Win2000 but also on
> Linux, AIX and Solaris. Where did we go wrong?
>
> Costas Stergiou wrote:
> > Hi all,
> > I saw no more comments on this suggestion. It is very simple to program
> > around this issu
if there is any
ansii char in the filepath.
Costas
> -Original Message-
> From: Costas Stergiou [mailto:[EMAIL PROTECTED]
> Sent: Saturday, August 05, 2006 11:47 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Problems opening db in win9x and utf8 filename
>
>
> >
&
>
> I no longer have a win98 system to test with, but based on my
> understanding...
>
> os_win.c attempts to convert the filename from UTF-8 to UTF-16. If it
> succeeds, it calls CreateFileW;
Actually, there is a flag there that caused the convertion to UTF-16 to
'fail' (it doesn't really
Hello,
I am encountering a problem trying to open a sqlite3 db (ver 3.3.6) using
the sqlite3_open function.
According to the docs, the file path should be utf8 encoded. If in the path
there are non-ansii chars, the following method fails in win98.
Tried the following:
1. Created an sqlite3 db in
> Hello,
>
> I need a server-less SQL engine. Unless someone recommends a better tool
> (embedded FireBird? Something else?), I'm thinking of using SQLite.
>
> Problem is, several wrappers are listed in the SQLite wiki. Can you
> recommend one, ideally under active development, easy to use, etc.
> The code compiles and runs for me. I am running the regression
> test suite as I type this and there are no problems so far. However,
> let me restate that I do not have the ability to test the behavior
> of SQLite in the presence of virus scanners and Tortoise SVN, so
> I am looking for
> SVN seems to be a standard shell extension which doesn't use low level
> drivers. It looks like it gets notification from Explorer and examines
> files that change. You see the same kinds of things happening when you
> try to delete media files in Windows when the shell's trying to
> examine
> The fix is very simple - uninstall the SVN software which causes the
> problem. I would imagine that Sqlite is not the only piece of software
> which expects to have exclusive access to its journals.
Well, I am the programmer in this case not the user :) Of course this would
fix the problem on
Can someone propose a reasonable workaround until this issue is fixed?
Is "synchronous=off" really a solution? Or there is a failure 'behind' the
scenes' that is just overlooked?
Not really knowing how difficult it is to overcome this issue (and just
trying to add an 'objective' opinion), I could
>
> If you continue to use the SVN software a work-around to try and bypass
> the race condition would be to retry the sqlite3_open after a short
> pause when you intercept a CANTOPEN status.
> JS
>
What is interesting here is that this error can happen at random moments
(e.g during an insert,
make SYNCHRONOUS=OFF you stop Sqlite from verifying that data
> has been written to disk. When you get this error does the journal file
> for that database still exist?
>
>
> Costas Stergiou wrote:
> > Hello John,
> > Thank you for your answer but I suspect this is
Windows XP SP2 with
> sqlite3_exec
>
> You don't test for an error on your close statement. I suspect that the
> Sqlite databases are not being closed because activity is not finalized.
> Your error pops up when you have a very large number of databases
open.
> JS
>
Hello everyone,
I lately came upon a very strange error that occurs at random times. I
managed to trace down and produce a small piece of code to reproduce it.
I am using Delphi and the sqlite3.dll (latest) but I am sure that this error
is not related to something other than the engine. Here is
14 matches
Mail list logo