Data types conversion chart

This is how the data types in your logical data model will change if you generate physical model from it.

Legend:

  • %n - length
  • %s - number of digits
  • %p - number of decimals
Type in logical modelParametersMySQLPostgresMicrosoft SQL ServerOracleIBM DB2HSQL DBSQLiteAmazon RedshiftGoogle BigQuery
Numeric
BytetinyintsmallinttinyintsmallintsmallinttinyinttinyintsmallintINT64
IntegerintintintintegerintegerintintegerintINT64
LongIntegerbigintbigintbigintintegerbigintbigintbigintbigintINT64
Serial%nserialserialintnumber(%n)integerintegerintegerintINT64
Decimal%s,%pdecimal(%s,%p)decimal(%s,%p)decimal(%s,%p)number(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)NUMERIC
Number%s,%pnumeric(%s,%p)numeric(%s,%p)numeric(%s,%p)number(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)numeric(%s,%p)NUMERIC
Money%s,%pdecimal(%s,%p)moneymoneynumber(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)NUMERIC
ShortFloatfloatrealrealfloatrealrealrealrealFLOAT64
Float%nfloat(%n)float(%n)float(%n)float(%n)doublefloatfloatfloatFLOAT64
LongFloatdoubledouble precisionfloatfloatdoubledoubledoubledouble precisionFLOAT64
String
Char%nchar(%n)char(%n)char(%n)char(%n)char(%n)char(%n)character(%n)char(%n)STRING
Varchar%nvarchar(%n)varchar(%n)varchar(%n)varchar2(%n)varchar(%n)varchar(%n)varchar(%n)varchar(%n)STRING
NChar%nnchar(%n)char(%n)nchar(%n)nchar(%n)char(%n)char(%n)character(%n)char(%n)STRING
NVarchar%nnvarchar(%n)varchar(%n)nvarchar(%n)nvarchar2(%n)varchar(%n)varchar(%n)varchar(%n)varchar(%n)STRING
Date and Time
DatedatedatedatedatedatedatedatedateDATE
Timetimetimetimedatetimetime--TIME
DateTimedatetimetimestampdatetimedatedatetimestampdatetimetimestampDATETIME
Timestamptimestamptimestampdatetime2timestamptimestamptimestampdatetimetimestampTIMESTAMP
Large and others
Text%nlongtexttexttextclobclob(%n)clob(%n)clob-STRING
Binary%nlongblobbyteavarbinary(%n)blobblob(%n)blob(%n)blob-BYTES
BooleanbooleanbooleanbitsmallintbooleanbooleanbooleanbooleanBOOL

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.