I have a sheet in Excel that has several rows and 16 columns. I will transform this sheet in a Derby database to work with Java.
To create the Derby database I need to specify the size of each column, so it would be great to know the maximum numbers of characters in a single row for that column, to optimize my Derby database.
Col A │ Col B │ Col C ──────┼───────┼────── a234 │ b2345 │ c2 a2 │ b23456│ c23 a23 │ b2 │ c234
4 │ 6 │ 4
I would like to do this without an extra column, but it seems impossible. Does anyone have a solution for that? Or what I want is unreal?