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
