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]
