what is the difference between char and varchar data types? : Sql dba
- 1 Answers
- 1203 Views
- I also Faced
- E-Mail Answers
Answer Posted / Husna Tabassum
The CHAR data type in SQL maintains a fixed length for each character field, even if the actual data stored is shorter. If the string is shorter than the specified length, it will be padded with spaces on the right side. On the other hand, the VARCHAR data type stores variable-length strings of up to a maximum size and does not pad spaces. This makes VARCHAR more space-efficient compared to CHAR.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the best sql course?
Is inner join faster than left join?
Can delete statement be rollbacked?
how to use regular expression in pattern match conditions? : Sql dba
what is dbms? : Sql dba
What is the current version of postgresql?
Can we use distinct and group by together?
define sql insert statement ? : Sql dba
Do we need to rebuild index after truncate?
What is your daily office routine?
what are the advantages of sql ? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Is primary key clustered index?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what are all the common sql function? : Sql dba
