Computer Science, asked by bhatanvita9, 1 month ago

Explain Char and Varchar datatypes.

Answers

Answered by joshiajay99aa

14

Answer:

It stores values in fixed lengths and are padded with space characters to match the specified length VARCHAR stores values in variable length along with 1-byte or 2-byte length prefix and are not padded with any characters

Answered by sshreedhar094

3

see the images...

VARCHAR is variable length, while CHAR is fixed length. CHAR is a fixed length string data type, so any remaining space in the field is padded with blanks. CHAR takes up 1 byte per character. ... VARCHAR is a variable length string data type, so it holds only the characters you assign to it.

Attachments:

Previous Question

Next Question

Similar questions

Math, 19 days ago

Quotient of 8 by n is less than 10...

Hindi, 19 days ago

मैं झील हूँ,उकता गई हूँ अब चाहती हूँ बहना,बौरा गई हूँ जो भी यहाँ आता है,खामोशियाँ लाता है। सुलझे हुए लोगों से, तंग आ गई हूँ। इस चाँद को तो देखो, मुझमें ही झाँकता है। अपने लम्हों को सीकर, हर रात काटता है कम्बखत ने कभी एक बात तक नहीं की धरती की अंजुली में घबरा गई हूँ पानी का एक सच है, वह सच है बहते जाना। रास्तों को छोड़ देना, रास्ते नए बनाना चाहा नहीं था मैंने, मैं रोकी गई हूँ। मैं झील हूँ,उकता गई...

Math, 19 days ago

3. Find the difference between cube of 51 and cube of 50...

Social Sciences, 1 month ago

name the ruling party of Mexico until 2000...

English, 1 month ago

Please don't do this please What are the main functions of cell Wall...

English, 8 months ago

Q1 Rewrite the following Simple Sentences as Compound Sentences: 1. The old man being weak could not walk properly. 2. His father in spite of being poor is a contended man. 3. She must work hard to be successful in the examination. 4. Our teacher is popular among students for his diligence. 5. Visualizing a danger ahead, the traveller became cautious. 6. The student must accept his fault to...

English, 8 months ago

Rearrange the parts of the sentence in correct order: Thus, P-a developing economy also needs Q-to have some notion of external balance R-at the very least, A) RPQ B) RQP C) PQR D) QPR...

English, 8 months ago

Four words are given, out of which only one word is spelt correctly. Choose the correctly spelt word and click the button corresponding to it. A) Beneficiary B) Benificiary C) Beneficeary D) Benefeciary...