CREATE TABLE t1 (a varchar(64) character set ucs2); #CREATE TABLE t1 (a varchar(64)); INSERT INTO t1 VALUES ("1.1"), ("2.1"); SELECT * FROM t1; update t1 set a= a + 0.1; SELECT * FROM t1; DROP TABLE t1;