Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.