John L. Singleton wrote : > >Hello all, > >I just found something in the docs that caught my attention. In the >documentation for the INTEGER: > >"INT[EGER]: This data type is the same as FIXED(10.0). Its permitted >values are between -2147483648 and 2147483647." > > >Is that statement correct? Integer values can range from >-2147483648 to >2147483647, however, FIXED(10,0) values can go from -9999999999 to >9999999999. > > >Any ideas? > > >Cheers, > >JLS >
I think that statement shall express that INT[EGER] and FIXED(10,0) have the same internal representation. You may imagine the data type INT[EGER] as a domain having the following definition : CREATE DOMAIN INTEGER FIXED(10) CHECK INTEGER BETWEEN -2147483648 AND 2147483647 Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
