Re: [sqlite] Dates & SQLite

[bizshop]

I use ISO time, which is 20080916122801 as I write this. It can be stored in
integer format, is very easy to manipulate and sort.
YearMonthDateHourMinuteSecond



Brown, Daniel wrote:
> 
> Good morning list,
> 
> Could someone point me to the documentation regarding dates and SQLite?
> I'm having trouble finding anything about what data type I should use to
> store dates in my SQLite tables, should it be a numerical type (integer
> or real) or a string?
> 
> Cheers,
> 
> Daniel Brown | Software Engineer @ EA Canada
> "The best laid schemes o' mice an' men, gang aft agley"
> 
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Dates---SQLite-tp19496074p19518812.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Determine version compatibility

[bizshop]

I am trying to use PHP and SQLite on N800 Nokia Internet Tablet - a great
handheld Linux based computer, but not exactly Linux (uses Maemo). That
means compiling is not an option for me, and most Linux things are 'ported'
over.

I can create a new database and insert from both command line and using php
pdo in the NGINX web server (localhost in browser), but in browser can't
access database created from commandline, and in commandline can't access
database created from browser/localhost. Both say "Encrypted or is not a
database"

Is there a way to get the version info from within PHP_PDO?  And are my
versions incompatible?

Anyway, I installed SQLite and from command line it shows SQLite version
3.3.5 

That one is easy.

When running NGINX web server as localhost and doing phpinfo() I get (0nly
applicable parts shown):

Configure command shows -with sqlite
PDO Drivers sqlite2, sqlite

in the pdo_sqlite section:
PDO Driver for SQLite 3.x enabled
PECL Module version (bundled) 1.0.1 $id:pdo_sqlite.c, v1.10.2.6.2.1. 
2007/01/01 sebastion Exp $
SQLite LIbrary 3.3.7

But then in the SQLite section 
SQLite support enabled
PECL Module  version 2.0-dev $id: sqlite.c, v 1.166.2.13.2.6 2007/01/01
sebastian Exp $
SQLite Library 2.8.17
SQLite Encoding iso8859

So I think it is creating databases in 3.3.7 - is that incompatible with
3.3.5?






-- 
View this message in context: 
http://www.nabble.com/Determine-version-compatibility-tf4576460.html#a13063321
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-