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
