Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.29_4.9.30_sqlserver.sql =================================================================== diff -u -r25661 -r25680 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.29_4.9.30_sqlserver.sql (.../4.9.29_4.9.30_sqlserver.sql) (revision 25661) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.29_4.9.30_sqlserver.sql (.../4.9.29_4.9.30_sqlserver.sql) (revision 25680) @@ -1 +1,2 @@ +update TousseInstance set weight=null where weight=''; alter table TousseInstance alter column [weight] float; \ No newline at end of file Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.29_4.9.30_oracle.sql =================================================================== diff -u -r25661 -r25680 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.29_4.9.30_oracle.sql (.../4.9.29_4.9.30_oracle.sql) (revision 25661) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.29_4.9.30_oracle.sql (.../4.9.29_4.9.30_oracle.sql) (revision 25680) @@ -1,3 +1,4 @@ +execute immediate 'update TousseInstance set weight='' where regexp_like(weight, '( )+')'; execute immediate 'alter table TousseInstance add weighttemp FLOAT'; execute immediate 'update TousseInstance set weighttemp = to_number(weight)'; execute immediate 'commit';