FourQ Data Types
FourQ uses a series of generic data-types internally that map to specific column data-types depending on the database in question.
Very much a work in progress...
data type | mysql | mssql | postgresql | oracle | Notes |
|---|---|---|---|---|---|
boolean | tinyint(1) | ||||
date | datetime | ||||
numeric | decimal(10,2) | ||||
string | varchar(255) | ||||
nstring | varchar(255) | ||||
uuid | varchar(50) | ||||
variablename | varchar(64) | ||||
color | varchar(20) | ||||
varchar(255) | |||||
longchar | longtext |
Comments
May 21, 2006
I am just beginning to learn about farcry. So I do not know a lot about farcry at this point. So, I am making an educated guess for the Oracle part with reference to Oracle 9.2.
boolean – There is not a boolean type used for table columns. Although, the boolean type can be used with Oracle's PL/SQL database programming language within packages, procedures, and functions, boolean types are not stored in the tables. I guess you would create a column type of number and store 1 or 0 or type char(1)/varchar2(1) with values 'T' or 'F'.
date – Oracle has two types for this, Date and Timestamp. The date type stores date and/or time values with precision in seconds. For example, the date type can store the following values:
2006-01-30 (YYYY-MM-DD)
2006-01-30 06:45:30 (YYYY-MM-DD HH:MI:SS)
The Timestamp type allows precision to fractional seconds as in the following example:
2006-05-11 09:26:50.124
Numeric - Number(p,s): Number having precision p and scale s. The precision p can range from 1 to 38. The scale s can range from -84 to 127 (Oracle docs).
String - varchar2(255)
Nstring - nvarchar2(255)
Uuid - varchar2(255)
Variable name - varchar2(64)
Color - varchar2(20)
Email - varchar2(255)
Longchar - clob or nclob (max size is 4 gigabytes)
I hope this will be helpful. Let me know if I need to clarify anything.