Friday, September 4, 2015 Tip of the Day: New Data Types in R:BASE X Enterprise Product: R:BASE X Enterprise (Version 10) Build..: 10.0.1.10820 or higher www.rbaseX.com Section.: General Keywords: Data Types, Variables
Several new data types are available within R:BASE X Enterprise, for use when designing tables and when defining variables. In addition to Super Powering R:BASE X Enterprise (Version 10) capabilities, this will help those who are also using R:BASE as a Front-End to retrieve and manage data when SCONNECTing/SATTACHing MS SQL, Oracle, and IBM DB2 database tables into R:BASE X Enterprise (Version 10). The BIGINT data type provides a much larger value, when the existing INTEGER limit has been reached. Both BOOLEAN and SMALLINT are data types that can be implemented to replace a TEXT (T/F)-type columns or small value INTEGER columns respectively, to help decrease the size of large databases. In short, the data types allows developers to hone the database structure to use the best available data type for the data being stored. The WIDENOTE and WIDETEXT data types columns are variations of NOTE and TEXT, that support the true storage of Unicode information. BIGINT . Holds a 64-bit integer value . Offers a range of ±999,999,999,999,999,999 . Delimiters (such as commas) cannot be used in entry . No length is needed BOOLEAN . Hold true/false values . Internally stored as 0 for false and 1 for true . Accepted values for false include: 0, false, 'false' . Accepted values for true include: 1, true, 'true' . For multilingual applications, the values of 0 and 1 are recommended SMALLINT . Holds a 16-bit integer value . Offers a range of ±32767 . Delimiters (such as commas) cannot be used in entry . No length is needed WIDENOTE . Holds Unicode data . The default length is 0, where the length is determined by the data . Holds variable length text of up to 4,092 characters . Maximum length of a WIDENOTE column can be set . Indexes and constraints are allowed on WIDENOTE data types . R:BASE reserves a minimum of four bytes of internal storage space, with 2 bytes per character WIDETEXT . Holds Unicode data . The default length is eight characters . The maximum is 1,500 characters . Maximum length of a WIDETEXT column can be set . R:BASE reserves a minimum of four bytes of internal storage space, with 2 bytes per character Very Best R:egards, Razzak. www.rbase.com www.rbaseX.com www.facebook.com/rbase
