# How to get table's Integer field column size??

Hetal Thakkar

Greenhorn

Posts: 5

posted 10 years ago

- 0

hii,

i am retriving table's cloumn sizes in which i am getting String column sizes perfectly by getColumnDisplaySize() method.but it doesnt give the size of any number field.it gives the 22 for all the integer columns....so is there any other method for this???

please give me quick reply...

i am retriving table's cloumn sizes in which i am getting String column sizes perfectly by getColumnDisplaySize() method.but it doesnt give the size of any number field.it gives the 22 for all the integer columns....so is there any other method for this???

please give me quick reply...

posted 10 years ago

- 0

Hetal,

What would it mean to have a size for an Integer? The number of digits?

The database stores an integer as data (bytes.) You could calculate the number of digits in a value (or in max int) yourself though.

What would it mean to have a size for an Integer? The number of digits?

The database stores an integer as data (bytes.) You could calculate the number of digits in a value (or in max int) yourself though.

[OCA 8 book] [OCP 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]

Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Hetal Thakkar

Greenhorn

Posts: 5

posted 10 years ago

- 0

hey,

i am using ResultsetMetaData,thru which i am taking max value which can be

inserted in the database.i am getting right values thru getCloumnDisplaySize() method for String column of a table.but it gives length of 22 for all integer values of all the tables in the database.i am creating dynamic insert query for which i am requing this..

i am using ResultsetMetaData,thru which i am taking max value which can be

inserted in the database.i am getting right values thru getCloumnDisplaySize() method for String column of a table.but it gives length of 22 for all integer values of all the tables in the database.i am creating dynamic insert query for which i am requing this..