Question

differentiate between char and varchar with their examples​

Answer 1

Answer:

Explanation:

The char datatype is used where user needs to deal with fixed length strings.

Syntax and example :

  variable_name Char(Size);

The default size of Char datatype is 1 and maximum size of the char datatype is 254.

The varchar datatype is used where user needs to deal with variable length data or string.

Syntax and example :

variable_name Varchar(Size);

The Length is unsigned integer constant.The maximum length for varchar2 is 32672.

Answer 2

Answer:

cczuDhSCjzfnxjrsjfaddykaddousjtshedjfftjsedhejskydjtftkdktdktstkstkskyekyeoydkydkydul