In a table created with query:
CREATE TABLE t (t1 varchar(20), t2 char(20))
the following record was inserted:
INSERT INTO t VALUES('test', 'test')
What will the following query return?
SELECT length(t1) t1, length(t2) t2 FROM t
Value of a char type will always have a lenght that was specified at table's creation. At the same time varchar length will be always equal to the length of the string that is actually stored.
SQL Quiz
Start Quiz

or Read more about SQL Quiz

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback