Hello,
I have few questions on SQLite3, i'm using it through
pdo with php5.
- is unsigned int available?
- can we insert a row with an autoinc primary key, so
I don't need to provide it when I insert a new row?
- if NULL values are possible for primary keys, then
autoinc key can't have this NULL on creation but can
get it on updates if we updates the key with NULL.
Right ?
-if NULL values are possibles and primary key is not
autoincremented then we have to supply the key during
insert, then there is a risk of having a NOT UNIQUE
error during insert and also during updates if we
supply a NULL value during updates. Right ?
- As I understood, it's recommended to add NOT NULL
for primary keys because SQLite allow NULL keys which
are equals to the first signed int (-xxx48) so it's
not unique if we have one row already and provide a
NOT UNIQUE error. Right ?
-is there a way to manage foreign keys ?
If unsigned int available for SQLite3 :
- can integer autoincrement primary keys be unsigned ?
- if we have an unsigned int primary key, with
autoinc, does it begins with 0 or 1 ?
About text type:
- What is the maximum value of a text data ?
- Do (') have to be escaped (\') in the text string ?
- is there any ready made function in php to escape
those (')?
Web links:
-Do you know good web tutorials, code samples,
opensource projects showing how to use SQLite mainly
with php and pdo ?
I read about it on php.net, litewebsite.com and
sqlite.org indeed.
Thanks
David
_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
