> 11 COMMENT VARCHAR(150) 0 0 > > So it is possible: ? > UPDATE t1 SET comment = 'here the text of 160 characters long'
Yes, that's possible. You can put text of any length into VARCHAR or TEXT field no matter what size you declare for it (you can even miss the size altogether, that won't make a difference). Pavel 2012/4/23 Ковригина Ольга <kofa_...@mail.ru>: > Mon, 23 Apr 2012 11:33:47 +0100 от Simon Davies > <simon.james.dav...@gmail.com>: >> 2012/4/23 Ковригина Ольга <kofa_...@mail.ru>: >> > Hello,support! >> > Tell me how to resize columns in a table? >> > I do like this: >> > ALTER TABLE t1 MODIFY (c1 TYPE VARCHAR(2500)); >> > or >> > ALTER TABLE t1 ALTER (c1 TYPE VARCHAR(2500)); >> > But it does not work. >> > >> >> The column does not have a size: >> http://www.sqlite.org/datatype3.html >> >> Regards, >> Simon >> > > That is, If I explicitly pointed out the size of the column 150, still can > not write to the text of any reasonable length? > > For example: > > Table t1 > cid name type notnull dflt_value pk > ------- -------------- ----------------- ----------- -------------- --- > 0 GLOBALID INTEGER 1 1 > 1 ID VARCHAR(30) 0 0 > ... > 11 COMMENT VARCHAR(150) 0 0 > > So it is possible: ? > UPDATE t1 SET comment = 'here the text of 160 characters long' > > > С уважением, > Ковригина Ольга > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
