RE: [sqlite] Problems opening db in win9x and utf8 filename

2006-08-05 Thread Costas Stergiou
> > 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

Re: [sqlite] Problems opening db in win9x and utf8 filename

2006-08-05 Thread Trevor Talbot
On 8/5/06, Costas Stergiou <[EMAIL PROTECTED]> wrote: 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 a path containing greek chars 2. Tried to open it

[sqlite] Re: sqlite using whole-file (not byte-range) locking

2006-08-05 Thread Adam Megacz
[EMAIL PROTECTED] writes: > In the latest versions of SQLite (3.3.0 and later) you can provide > SQLite with customized locking code at run-time. So you can > easily add AFS support that uses whole-file locking instead of > the goofy byte-range stuff I have to do for Win95. That's fantastic.

Re: [sqlite] Problems opening db in win9x and utf8 filename

2006-08-05 Thread Peter Cunderlik
On 8/5/06, Costas Stergiou <[EMAIL PROTECTED]> wrote: 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

Re: [sqlite] Insert delay!

2006-08-05 Thread John Stanton
Cesar David Rodas Maldonado wrote: I was thinking a lot in the next month in how can I do the delay insert and I found something for do that, is basic because I don't have a lot of knowledge, I'm just start the University. OK, I need with SQLite to select all the time as possible, and delay the

[sqlite] Problems opening db in win9x and utf8 filename

2006-08-05 Thread Costas Stergiou
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

Re: [sqlite] date data types

2006-08-05 Thread John Stanton
Will Leshner wrote: On 8/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Adding DATE and TIMEINTERVAL types to SQLite would require an incompatible file format change. And it would go against the basic philosophy of SQLite. I wonder if it might not be useful to be able to ask SQLite if

Re: [sqlite] Insert delay!

2006-08-05 Thread Cesar David Rodas Maldonado
Your all right! what i am doing right know is cache the insert query and execute when the is not select, and that is almost working. When i was developing my "insert delay" I thought that will be great is SQLite support an option like MySQL (insert delay). And i dont wanna use Postgresql,

Re: [sqlite] Insert delay!

2006-08-05 Thread Clay Dowling
Cesar David Rodas Maldonado wrote: I was thinking a lot in the next month in how can I do the delay insert and I found something for do that, is basic because I don't have a lot of knowledge, I'm just start the University. OK, I need with SQLite to select all the time as possible, and delay the

Re: [sqlite] Re: Help on triggers

2006-08-05 Thread John Newby
Hi Igor, thanks for your help. Is the 'WHEN' clause used very often when creating triggers or do you think I could get away with leaving it out? I am unsure as what to put in the expression part of the WHEN clause in order to test it thoroughly. Also does anyone have a test database I could

[sqlite] Re: Help on triggers

2006-08-05 Thread Igor Tandetnik
John Newby <[EMAIL PROTECTED]> wrote: do you only need the column name when "UPDATE OF" is chosen and not the other 3? Correct. do you need either "BEFORE" or "AFTER" only when "INSERT", "DELETE", or "UPDATE" are chosen, but not when "UPDATE OF" is chosen? BEFORE and AFTER keywords are

[sqlite] Help on triggers

2006-08-05 Thread John Newby
Hi, I am creating a GUI to SQLite for my final year projectat University so that the user need not know SQL in order to create a database. I am having trouble when trying to create triggers. The example shown on th SQLite website only shows one example for "UPDATE OF" which seems to be the

[sqlite] Insert delay!

2006-08-05 Thread Cesar David Rodas Maldonado
I was thinking a lot in the next month in how can I do the delay insert and I found something for do that, is basic because I don't have a lot of knowledge, I'm just start the University. OK, I need with SQLite to select all the time as possible, and delay the Insert, I don't care the time

Re: [sqlite] UNICODE Support

2006-08-05 Thread Nathaniel Smith
On Fri, Aug 04, 2006 at 10:02:58PM -0700, Cory Nelson wrote: > On 8/4/06, Trevor Talbot <[EMAIL PROTECTED]> wrote: > >On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote: > > > >> But, since you brought it up - I have no expectations of SQLite > >> integrating a full Unicode locale library, however

Re: [sqlite] From Windows file format to MacOSX (unsuccessfull)

2006-08-05 Thread Alexander Lamb
Well, it didn't seem to work when I copied the file to MacOSX. It said (after accepting to go into command line mode) "invalid file format". I don't have an intel box to test now, so I will try again on monday at the office. My other option is to save the data in 2.8 format and convert from

Re: [sqlite] UNICODE Support

2006-08-05 Thread Trevor Talbot
On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote: On 8/4/06, Trevor Talbot <[EMAIL PROTECTED]> wrote: > On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote: > > > But, since you brought it up - I have no expectations of SQLite > > integrating a full Unicode locale library, however it would be a