By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

VARCHAR field memory storage

P: 24
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).?
Nov 21 '07 #1
Share this Question
Share on Google+
2 Replies


nearestniladri
P: 5
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.
Nov 21 '07 #2

P: 3
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
Dec 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.