HomeОбразованиеRelated VideosMore From: Geeky Shows

11. CHAR, VARCHAR and TEXT Data Type in SQL (Hindi)

207 ratings | 40068 views
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Html code for embedding videos on your blog
Text Comments (14)
Salman Al Punjabi (1 month ago)
booooooo
HYPER乄 WALEED (5 months ago)
255 hi hai 2554343455 nahi hai 255 ko kabhi 25 bola 225 bola kya hai??
Pristine Animation (7 months ago)
thanks bro
Pathik Joshi (7 months ago)
There is huge difference between char(50) and varchar(50), yadi char(50) ho to, har record me uske liye 100 bytes allocate karni padegi, jisme yadi record kam character ka raha to utni memory waste ho jaayegi. jabki varchar(50) ho to, usme jitna character insert hoga utni hi memory occupy hogi.
Devanshu Shaurya (8 months ago)
bokka h ye
you tube (9 months ago)
bhai ye fixed length string aur variable length string me kya antar hai plz btao
Venkatesh Gupta (8 months ago)
Suppose you define: - enrollmentid char(5) and you insert enrollmentid = '12' 3 character spaces are left. (We allocated 5 character space but used two) 1 2 _ _ _ (Since char is a fixed length string, the three spaces are padded) SQL counts that every enrollmentid uses 5 bytes. Not in the case of enrollmentid varchar(5) There would be extra right padding. Enrollment id would be of 2 bytes only. Rest 3 bytes are unused. While in char all the allocated 5 bytes are considered. 2 bytes for 12 and the rest three as padded spaces.
sana mirza (1 year ago)
hi..can u help me make my assignment syntax plz
CSEtutorials (1 year ago)
may i ? what actually u want ?
Deepam Paul (1 year ago)
can you mail these. study material
Gaurav Chauhan (2 years ago)
apki java ki videos bhi complete hai kya mtlb core and advanced both ?
Gaurav Chauhan (2 years ago)
are these videos complete SQL tutorial?
Syed Ali Haider (2 years ago)
total kitni hoti hai
Syed Ali Haider (2 years ago)
salam sir im haider sir how many data types please tell me i need data types

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.