[sqlite] Right() function

Hi, Does SQLite supports the right(string, len) function ? For instance : SELECT myfield, right(myfield,5) FROM mytable where myfield = "aaa"; I've got an error near '(' when executing this request. Thanks. Ce message est prot?g? par les r?gles relatives au secret

[sqlite] Need help - "Missing extension for native"

Hi, I'm working with Php4, SQLite and ADOdb. I'm trying to open a database. See my code : $db = ADONewConnection('sqlite'); $db->debug = true; $db-> connect('','','','test.sdb'); $rs = $db->Execute('select * from table_test'); print_r($rs->getRows()); The

[sqlite] Character set

Hi, is it possible to specify the character set for a table ? I would like my data to be in latin1 instead of utf-8. Thanks ! Ce message est prot?g? par les r?gles relatives au secret des correspondances. Il est donc ?tabli ? destination exclusive de son destinataire. Celui-ci peut donc

Re: [sqlite] index in CREATE TABLE

Mario Frasca a écrit : Cécilia Vigny wrote: With MySQL, it's possible to declare an index in CREATE TABLE, using KEY, like in this example : CREATE TABLE table_name ( id int(6) NOT NULL auto_increment, field_name date default NULL, PRIMARY KEY (id), KEY idx_field_name (fieldname

[sqlite] index in CREATE TABLE

Hi, With MySQL, it's possible to declare an index in CREATE TABLE, using KEY, like in this example : CREATE TABLE table_name ( id int(6) NOT NULL auto_increment, field_name date default NULL, PRIMARY KEY (id), KEY idx_field_name (fieldname), ) ; I want to know if there is an