Click above to get retro games delivered to your door ever month!

Appendix A
RaSQL / Btrieve Data Types

The table below lists Btrieve data types and their associated RaSQL type 
codes.  The first letter of each type code corresponds to the most closely 
related Clipper type code (i.e., C, N,  etc.).  Names in parentheses are the 
names commonly used in Btrieve manuals.


RaSQL   Btrieve                                    FIELD_LEN    FIELD_SLEN
Code     Code   Description                        (display)    (internal)
                                                                          
  C        0    Character                             1-255         1-255 
  CL      10    Pascal character (LSTRING) *          1-254         2-255 
  CT       4    Time                                      8             4 
  CZ      11    Asciiz (ZSTRING)                      1-254         2-255 
  D        3    Date                                      8             4 
  L        7    Logical                                   1          1, 2 
  M       12    Memo (NOTE)                         1-65534       2-65535 
  ML      13    Pascal Memo (LVAR)                  1-65533       3-65535 
  N        8    Numeric                                1-19          1-19 
  NB       9    Basic Floating Point (BFLOAT)          1-19          4, 8 
  NC      17    Cobol Numeric (NUMERICSTS)             1-19          1-20   
  NF      2     IEEE Floating Point (FLOAT)            1-19          4, 8   
  NI      1     Integer                                1-10       1, 2, 4 
  NP      5     Packed Decimal (DECIMAL) **            1-19          1-10   
  NU      14    Unsigned Integer                       1-10         1,2,4  
  N+      15    Autoincrement Integer                  1-10          2, 4   
  N$      6     Packed Decimal (MONEY) **              1-19          1-10   

*  A Pascal String is one in which RaSQL/B stores the string length at the 
   beginning of the string. It is useful for storing binary data.

** Packed Decimal stores two numeric digits in each byte, so generally takes 
   up half the space on disk as the equivalent Numeric. NP is more flexible 
   than and preferable to N$. For the most part,  Btrieve treats 
   Autoincremented Integer fields as standard integers. However, if you 
   issue N_XINSERT() or N_XUPDATE() while leaving the field value at zero, 
   Btrieve will automatically assign it the current highest value plus one.