> -----Original Message----- > From: Rodman Holland [mailto:[EMAIL PROTECTED] > Sent: Monday, March 03, 2003 3:43 PM > To: [EMAIL PROTECTED] > Cc: David Possinger > Subject: SAP DB Data Type Question > > > Hello. Am I correct in understanding that INTEGERs > within the SAP DB have to be 1, 2, or 4 bytes long?
No. Numbers including INTEGERs are stored in a decimal representation, so an INTEGER is from the database point of view a FIXED(10,0) with a limited domain range (-2^32 ... +2^32-1). > If so, > is DECIMAL(0) the preferred alternative for holding unsigned > integers to be imported? What is the preferred alternative > for signed integers? Thanks for responding. If you want to enables special checks not supported by one of the number types, try using a domain. See http://www.sapdb.org/7.4/htmhelp/6d/117c23d14811d2a97400a0c9449261/content.htm for more details on this. Regards Alexander Schr�der SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
