Monday, 28 April 2014

How many bytes a character column is storing ?

How many bytes a character column is storing ?

CHARACTER_LENGTH(<COLUMN>,OCTETS)
Use the select below to find how many bytes a character column is storing in your database
db2 "SELECT CHARACTER_LENGTH(NAME,OCTETS) FROM TABLEX"
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)