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

2009-09-22 Thread P Kishor
On Tue, Sep 22, 2009 at 8:39 AM, Angus March wrote: > P Kishor wrote: >> On Mon, Sep 21, 2009 at 5:10 PM, Guillermo Varona Silupú >> wrote: >> >>> Hi >>> In these SQL commands: >>> >>> CREATE TABLE "test" ("code" char(2)); >>> INSERT INTO test (code) VALUES("123") >>> >>> Why are allowed to keep

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

2009-09-22 Thread Ribeiro, Glauber
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Angus March Sent: Tuesday, September 22, 2009 8:40 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Why are allowed to keep a text of 3 characters in a field

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

2009-09-22 Thread Angus March
P Kishor wrote: > On Mon, Sep 21, 2009 at 5:10 PM, Guillermo Varona Silupú > wrote: > >> 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? >

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

2009-09-21 Thread Guillermo Varona Silupú
Ok. Simon and P Kishor. Thank very much for your response BestRegards GVS Simon Davies escribió: > 2009/9/21 Guillermo Varona Silupú : > >> 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

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

2009-09-21 Thread P Kishor
On Mon, Sep 21, 2009 at 5:10 PM, Guillermo Varona Silupú wrote: > 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? nope. It is by desig

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

2009-09-21 Thread Simon Davies
2009/9/21 Guillermo Varona Silupú : > 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? No - I suggest that you have a look at http://www.

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

2009-09-21 Thread Guillermo Varona Silupú
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 sqlite