Re: [sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

Ok. Simon and P Kishor. Thank very much for your response BestRegards GVS Simon Davies escribió: > 2009/9/21 Guillermo Varona Silupú <gvaro...@hotmail.com>: > >> Hi >> In these SQL commands: >> >> CREATE TABLE "test" ("code" char

[sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

Hi In these SQL commands: CREATE TABLE "test" ("code" char(2)); INSERT INTO test (code) VALUES("123") Why are allowed to keep a text of 3 characters in a field that has been set to 2? Is a bug? TIA BestRegards GVS ___ sqlite-users mailing list

Re: [sqlite] How can I do to build this query with a text that contains ' and "?

Thanks, now work fine BestRegards GVS Simon Davies escribió: > 2009/9/20 Guillermo Varona Silupú <gvaro...@hotmail.com>: > >> Hi >> I want to insert this text: >> >> 1' equivale a 12" >> >> cQry := "INSERT INTO Tabla1 (Code,

[sqlite] How can I do to build this query with a text that contains ' and "?

Hi I want to insert this text: 1' equivale a 12" cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"") TIA Best Regards GVS P.D.: Sorry for the post past and my bad english ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Most wanted features of SQLite ?

Hi I want to insert this text: 1' equivale a 12" cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"") TIA Best Regards GVS ___ sqlite-users mailing list sqlite-users@sqlite.org