Get the App
SLTechnology News&Howtos  ›  Database  › 

Sort out part of the java code and compare the data types with oracle,mysql,sql server

Shulou Source: shulou.com Published: 2022-06-01 13:02:03 11月17日 Update

After searching for the comparison of data types on the Internet, there is almost no comparison of the three databases, so I wrote the comparison of some fields. If there is anything wrong, please do not hesitate to comment.

JAVA field oracle field mysql field sql server field intnumberintintjava.lang.doublenumber (pjings) doublefloatjava.lang.Stringvarchar2varcharvarcharjava.sql.Datedatedate (year) datetime2java.sql.Timedatetimedatetime2java.math.BigDecimalnumberbigintdecimal (money,smallmoney,numeric) java.lang.floatnumberfloatrealjava.lang.shortnumbervarcharvarcharjava.lang.booleannumberbitbit

Java.lang.bytevarchar2varcharvarcharjava.lang.longnumberintegerbigint

Tags: Fields data types no don't hesitate to give advice places databases search code parts Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi MySQL Linux Shulou Information vpn