difference between Text (fix) [CHAR] and Text [VARCHAR].

Q3. What is the difference between Text (fix) [CHAR] and Text [VARCHAR]?

Ans. The differences between the Text (fix) [CHAR] and Text [VARCHAR] data types are as follows:

 

Text (fix) [CHAR]

Text [VARCHAR]

Represents a text data type of fixed length. Represents a text data type of variable length.
If the data that you enter is less than the length specified, then the field is completed by trailing spaces. If the data that you enter is less than the length specified then the field is not completed by trailing spaces.

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: