-
CHAR stores alphanumeric characters of fixed size
-
Stores alphanumeric characters of variable length
-
to create scripts containing infinite characters
-
Type as many characters as you want
EXPLANATION
The only difference between CHAR and VARCHAR2 is that CHAR
stores fixed-length alphanumeric characters, between 1 and 2000 bytes or
characters. If you are stored in the JUNIOR surname in a CHAR (50)
column, a column will contain a JUNIOR string + 44 whitespaces that are
automatically added to the total column volume.
SOURCE
http://www.fabioprado.net/2011/08/qual-tipo-de-dado-devo-usar-char.html
0 comments:
Post a Comment