Wednesday, January 23, 2008

What is difference between char(1999) and varchar2 (1999)

CHAR is always 1999 characters long physically AND logically. But the varchar is physically 1999 bytes but logically can be any size in between 0 and 1999. The char is always blank padded, not so for the varchar.

No comments: