跳到主要内容

JASS 数据类型对照表

Java/TypeScript/C#

Java 数据类型C# 数据类型TypeScript 数据类型
intintnumber
longlongnumber(with BigInt)
floatfloatnumber
doubledoublenumber
booleanboolboolean
charcharstring (single-char)
Stringstringstring
List<T>List<T>Array<T>
Map<K, V>Dictionary<K, V>Record<K, V>
Set<T>HashSet<T>Set<T>
TupleTuple typesTuple types
enumEnumEnum
Objectobjectany
voidvoidvoid
null / undefinednull / undefinednull / undefined
java.sql.Timestampjava.time.LocalDateTime DateTime

Java Compare table with data type

JavaMySQLPostgreSQLOracleSQL ServerInfluxDB
java.lang.BooleanBOOLEANBOOLEANNUMBER(1)BITBOOLEAN
java.lang.ByteTINYINTSMALLINTNUMBER(3)TINYINT
java.lang.ShortSMALLINTSMALLINTNUMBER(5)SMALLINT
java.lang.IntINTINTEGERNUMBER(10)INT
java.lang.LongBIGINTBIGINTNUMBER(19)BIGINTINT
java.lang.FloatFLOATREALNUMBER(带小数点)REAL
java.lang.DoubleDOUBLEDOUBLE PRECISIONNUMBER(带小数点)FLOATREAL
java.lang.StringVARCHARTEXTVARCHARTEXTVARCHAR2CLOB
java.math.BigDecimalDECIMALNUMERICNUMERICNUMBERDECIMAL
java.sql.DateDATEDATEDATEDATE
java.sql.TimeTIMETIMEDATE(仅时间部分)TIME
java.sql.TimestampDATETIMETIMESTAMPTIMESTAMPTIMESTAMPDATETIME
java.sql.ArrayARRAYARRAYTABLETABLE
java.sql.BlobBLOBBYTEABLOBVARBINARY
java.sql.ClobCLOBTEXTCLOBTEXT
java.time.InstantTIME
java.time.LocalDateTimetimestamp without time zone

C# Compare table with data type

C#MySQLPostgreSQLOracleSQL ServerInfluxDB
boolBOOLTINYINT(1)BOOLEANNUMBER(1)BIT
byteTINYINT UNSIGNEDSMALLINTNUMBER(3)TINYINT
shortSMALLINTSMALLINTNUMBER(5)SMALLINT
intINTINTEGERNUMBER(10)INTINT TIME
longBIGINTBIGINTNUMBER(19)BIGINT
floatFLOATREALNUMBER(带小数点)REALFLOAT
doubleDOUBLEDOUBLE PRECISIONNUMBER(带小数点)FLOATREAL
decimalDECIMALNUMERICNUMERICNUMBERDECIMAL
stringVARCHARTEXTVARCHARTEXTVARCHAR2
charCHARCHARVARCHAR(1)CHARCHAR
DateTimeDATETIMETIMESTAMPTIMESTAMPDATETIMESTAMP
byte[]BLOBBYTEABLOBVARBINARY
GuidCHAR(36)UUIDRAW(16)UNIQUEIDENTIFIER
EnumENUMENUM(PostgreSQL 8.3+)VARCHAR2NUMBERINT
System.Net.IPAddressVARBINARY(16)INET(PostgreSQL 9.4+)RAW(4)VARBINARY(16)
System.Net.IPAddressRange-CIDR(PostgreSQL 9.4+)--
System.Numerics.BigIntegerDECIMALNUMERICNUMERICNUMBERDECIMAL
jsonSystem.Text.Json.JsonDocumentJSONJSONBJSONJSONB
DateTimeTIMESTAMP WITHOUT TIME ZONE