The following table shows the possible types of data in Oracle, and the type to which they are mapped in Beta:
| Varchar | Text |
| Number | RealObject |
| Integer | IntegerObject |
| Float | RealObject |
| String | Text |
| Varnum | IntegerObject |
| Long | IntegerObject |
| RowID | IntegerObject |
| Date | Time |
| VarRaw | Unsupported type |
| Raw | Unsupported type |
| Long Raw | Unsupported type |
| Unsigned Int | IntegerObject |
| Long Varchar | Text |
| Long VarRaw | Unsupported type |
| Char | Text |
| CharZ | Text |
| RowID | Unsupported type |
| Named Datatype | Unsupported type |
| Ref | Unsupported type |
| CLOB | Unsupported type |
| BLOB | Unsupported type |
| Binary File | Unsupported type |
| OCI String | Unsupported type |
| OCI Date | Unsupported type |
The following table shows the possible types of data in FrontBase, and the type to which they are mapped in Beta:
| Boolean | booleanObject |
| Integer | integerObject |
| SmallInt | integerObject |
| Float | realObject |
| Real | realObject |
| Double precision | realObject |
| Numeric | realObject |
| Decimal | realObject |
| Char | text |
| VarChar | text |
| Bit | Unsupported type | VarBit | Unsupported type |
| Date | time (with hh:mm:ss = 00:00:00) |
| Time | time (with yy-mm-dd = 00-01-01) |
| TimeTZ | Unsupported type | Timestamp | time (with both date and time set) |
| TimestampTZ | Unsupported type |
| YearMonth | Unsupported type |
| DayTime | Unsupported type |
| CLOB | Unsupported type |
| BLOB | Unsupported type |
The following table shows the possible types of data in MySQL, and the type to which they are mapped in Beta:
| Decimal | integerObject |
| Tiny | charObject |
| Short | integerObject |
| Long | integerObject |
| Float | realObject |
| Double | realObject |
| VarString | text |
| String | text |
| Null | Unsupported type |
| Timestamp | Unsupported type |
| Longlong | text |
| Int24 | Unsupported type |
| Date | time | DateTime | Unsupported type |
| Year | Unsupported type |
| NewDate | Unsupported type |
| Enum | Unsupported type | Set | Unsupported type |
| TinyBLOB | Unsupported type |
| MediumBLOB | Unsupported type |
| LongBLOB | Unsupported type |
| BLOB | Unsupported type |
| The BetaDBC Library - Reference Manual and Tutorial | © 1999-2004 Mjølner Informatics |
[Modified: Friday September 7th 2001 at 12:45]
|