How Can We Help?
Datatype to database mappingsDatatype to database mappings
Datatype |
Postgres |
Oracle |
MSSQL |
|---|---|---|---|
| Double | Numeric | Number | Float |
| Long | Numeric | Number | Int |
| Integer | Numeric | Number | Int |
| Date | Date | Date | Date |
| String | Varchar | Varchar | Varchar |
| String/Clob | Text | Clob | Ntext |
| String/Blob | Bytea | Blob | Image |
| Classification | Varchar | Varchar | Varchar |
| Boolean | Boolean | Numeric(1,0) | Bit |
Updated at July 27, 2024