Are varchar(50) and varchar(10000) the same?

Question

I have read a article that claim varchar(10000) would use more ram than varchar(50), but I have doubt with it. I have run a simple test:

create table 'big' with one field varchar(16383)
create table 'small' with one field varchar(50)
insert same data to both table
run 'select *' for each table, see its executing time
run 'SELECT CONCAT(TRUNCATE(SUM(data_length),2),'B') AS data_size FROM information_schema.tables' for each table, see its data_size

The results of step 4 and step 5 is exactly the same between tables. I have running MySQL 8.0 with innodb. Is there actually has different with varchar(50) and varchar(10000) during query process?

Well apart from the obvious one, what difference are you trying to test for — RiggsFolly, May 10 '22 at 07:47
The difference will be to do with indexing and query speed on filtering and sorting and not the size on the disk. — , May 10 '22 at 07:55

score 0 · Answer 1 · edited May 15 '22 at 09:14

0

About query process there is no difference , varchar(50) and varchar(10000) are just for number of characters the field will contain. its the same with 50 characters and with 10000 for query process , but if you try to use orderBy the response using these fields as reference than it could matter - if you have 10,000 characters of data in your rows.

edited May 15 '22 at 09:14

Wilson Hauck

2,094
1
11
19

answered May 10 '22 at 07:53

roberto cemeri

1
2

Are varchar(50) and varchar(10000) the same?

1 Answers1