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] -----------------------------------------------------------------------------