VARCHAR field memory storage

[robintwos]

A field declared as VARCHAR(10) , how many bytes of data it can occupy ?
and
can i move a field which is declared as VARCHAR(10) to CHAR(10).?

[nearestniladri]

A field declared as VARCHAR(10) , how many bytes of data it can occupy ?
and
can i move a field which is declared as VARCHAR(10) to CHAR(10).?

Hello,
You cannot change varchar to character. Because this kind of conversion is not supported by DB2. As all this memory conversion functions are not allowed in DB2 storage.

[db2doubts]

Hello,

VARCHAR field memory storage depends on entering the text in this field
e.g if you enter 5 charaters then DB2 allot for 5 bytes only but coming to CHAR datatype DB2 allot 10 bytes either u enter or not