Hi Just to let you know - Jean split the mail off here from the thread on the Tutorial to one about the User guide. Which by the way will have cross over content I hope.
But I'll send the response to your questions back via the thread on the tutorial - other wise I get lost on what is for which project. FYI - need to work on another project today and will be putting together your response tomorrow, just so you know I haven't missed the question. OK On 9/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi Andrew! > > Thank you very much for the Hsqldb manual and the links that you sent me. > They proved to be very useful. The site in Portuguese never opened in my > browser so I could not check it. > > However, I was able to gather most of the information that I needed... > with a few exceptions; and I am hoping that you can fill in the gaps: Data > types are not defined in the Hsqldb manual but referred to the Java types > they map (pag. 115). I really just want to identify the number of bytes > they use and whether they are signed or not in order to determine their > range. For example, I understood that TINYINT was a 1 byte unsigned data > type with a range of 0-255. Yet the manual says -under the Types and > Arithmetic Operators heading- that TINYINT ranged from -128 to +127. > Ahhrg! > > I also understand that NUMERIC and DECIMAL are interchangeable in Hsql > (which is the engine this tutorial will assume that the user is using) and > can hold very large numbers and that REAL, FLOAT and DOUBLE, also > interchangeable, handle better the divisions. Is this consistent with your > experience? > > To simplify what I am asking from you, could you please review and > complete- the best you can- the following table? (I really hope that the > formatting holds!): > > Numeric Type Variables: Used for storing numeric values > > Name Data type No. of Bytes Signed Range > Boolean yes/no 1 bit ---- 0 - 1 > Tinyint Tiny Integer 1 Byte No 0 – 255 > Smallint Small Integer > Integer Integer > Bigint Big integer > Numeric Number no limit (>1MB) > Decimal Decimal no limit (>1MB) > Real Real > Float Float > Double Double > > I have chosen to leave the size, precision and scale attributes for an > advanced tutorial. I am also going to assume that the lax operation mode > in the handling of variable types is on by default when using Hsql. > > I appreciate your help! > > Mariano > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
