A script-enabled browser is required for this page to function properly.

CHAR Replaced by VARCHAR2

In PL/SQL V1, the datatypes CHAR and VARCHAR2 could be used interchangeably. In versions after V1, the CHAR datatype is right padded with blanks.

In PL/SQL V1, this statement:

 var1 CHAR(10) := 'hello';

. . .is equal to 'hello'.

In versions after V1, however, this statement resolves to 'hello ', (a total of ten characters).

To preserve the V1 behavior of CHAR variables, the conversion utility replaces all CHAR(n) declarations with the equivalent VARCHAR2(n) statement. In the example above, var1 becomes VARCHAR2(10).

The conversion utility also replaces all VARCHAR statements with the equivalent VARCHAR2 expression.