Search With Seek4Info.com
Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.

Contact: aviboots(AT)netvision.net.il

Instant Grammar Checker - Correct all grammar errors and enhance your writing

Secure & Reliable Web Hosting, Free Domain, Free SSL, 1-Click WordPress Install, Expert 24/7 Support

Semrush - keyword research tool

Boost your online presence with premium web hosting and servers

Most popular tags

python java c c# cpp javascript php vb# typescript nodejs go rust scala swift kotlin html pascal dart ruby r css bootstrap groovy sql win32 mysql winapi jquery lua winforms bash pascal-string f# opengl kotlin-string swift-string go-string c-string cpp-string vbnet-string scala-string c#-string pascal-array cobol rust-string php-string java-string javascript-string python-string php-array cpp-vector swift-array typescript-string reactjs c-array javascript-array c-windows typescript-array python-list rust-vector scala-array go-array nodejs-array sdl2 nodejs-string kotlin-array nodejs-express cpp-array sdl3 angularjs c#-list vbnet-list java-array c#-array raylib glfw vbnet-array javascript-regex cpp-matrix typescript-regex freeglut html5 nodejs-regex php-regex cpp-regex glew c#-matrix go-slice c-matrix swift-regex kotlin-regex scala-regex go-regex python-regex kotlin-list perl swift-matrix pascal-matrix scala-list java-list
Disclosure: My content contains affiliate links.

38,119 questions

49,726 answers

573 users

What is the difference between CHAR and VARCHAR types in MySQL



112 views
asked May 27, 2024 by avibootz
Share on
share on gp share on fb share on tw share on li share on re share via email

1 Answer

0 votes 
--
-- Value      CHAR(4) > Storage    VARCHAR(4) > Storage
-- ''         '    '    4 bytes    ''           1 byte
-- 'ab'       'ab  '    4 bytes    'ab'         3 bytes
-- 'abcd'     'abcd'    4 bytes    'abcd'       5 bytes
-- 'abcdef'   'abcd'    4 bytes    'abcd'       5 bytes
--

 



answered May 27, 2024 by avibootz

Related questions

1 answer 178 views
178 views
What are the MySQL Data Types?
asked Sep 27, 2015 by avibootz
1 answer 99 views
99 views
What database field type to choose for a URL in MySQL
asked May 26, 2024 by avibootz
1 answer 187 views
187 views
What to set to write hebrew in MySQL with PHP
asked Nov 16, 2020 by avibootz
1 answer 69 views
69 views
What is the difference between char s[] and char *s in C
asked May 24, 2024 by avibootz
1 answer 227 views
227 views
What is the difference between char array[] and char *p in C
asked Aug 11, 2019 by avibootz
 | Search With Seek4Info.com
Powered by Question2Answer
...