一、C# vs SQLite: C#SQLite 字段名%ignore_a_1%库类型GetFieldType(#)转换备注 F_BOOLboolBIT NOT NULLBoolean F_BOOL_NULLbool?BITBoolean F_SBYTEsbyteINT8 NOT NULLSBytesbyte_ F_SBYTE_NULLsbyte?INT8SBytesbyte_ F_BYTEbyteUINT8 NOT NULLByte F_BYTE_NULLbyte
一、c# vs sqlite:
C#SQLite
字段名类型库类型GetFieldType(#)转换备注
F_BOOLboolBIT NOT NULLBoolean
F_BOOL_NULLbool?BITBoolean
F_SBYTEsbyteINT8 NOT NULLSBytesbyte_
F_SBYTE_NULLsbyte?INT8SBytesbyte_
F_BYTEbyteUINT8 NOT NULLByte
F_BYTE_NULLbyte?UINT8Byte
F_SHORTshortINT16 NOT NULLInt16
F_SHORT_NULLshort?INT16Int16
F_USHORTushortUINT16 NOT NULLUInt16ushort_
F_USHORT_NULLushort?UINT16UInt16ushort_
F_INTintINT32 NOT NULLInt32
F_INT_NULLint?INT32Int32
F_UINTuintUINT32 NOT NULLUInt32uint_
F_UINT_NULLuint?UINT32UInt32uint_
F_LONGlongINT64 NOT NULLInt64
F_LONG_NULLlong?INT64Int64
F_ULONGulongUINT64 NOT NULLUInt64ulong_
F_ULONG_NULLulong?UINT64UInt64ulong_
F_FLOATfloatFLOAT NOT NULLDouble 不转兼容
F_FLOAT_NULLfloat?FLOATDouble 不转兼容
F_DOUBLEdoubleDOUBLE NOT NULLDouble
F_DOUBLE_NULLdouble?DOUBLEDouble
F_DECIMALdecimalDECIMAL NOT NULLDecimal 存取不一：: [-79228162514264300000000000000] != [-79228162514264337593543950335]
F_DECIMAL_NULLdecimal?DECIMALDecimal 存取不一：: [-79228162514264300000000000000] != [-79228162514264337593543950335]
F_CHARcharTEXT NOT NULLString
F_CHAR_NULLchar?TEXTString
F_STRINGstringTEXT NOT NULLString
F_STRING_NULLstringTEXTString
F_DATETIMEDateTimeTEXT NOT NULLString
F_DATETIME_NULLDateTime?TEXTString
二、 C# vs MySQL:
C#MySQL
字段名类型库类型GetFieldType(#)转换备注
F_BOOLboolBOOL NOT NULLBoolean
F_BOOL_NULLbool?BOOL NULLBoolean
F_SBYTEsbyteTINYINT NOT NULLSBytesbyte_
F_SBYTE_NULLsbyte?TINYINT NULLSBytesbyte_
F_BYTEbyteTINYINT UNSIGNED NOT NULLByte
F_BYTE_NULLbyte?TINYINT UNSIGNED NULLByte
F_SHORTshortSMALLINT NOT NULLInt16
F_SHORT_NULLshort?SMALLINT NULLInt16
F_USHORTushortSMALLINT UNSIGNED NOT NULLUInt16ushort_
F_USHORT_NULLushort?SMALLINT UNSIGNED NULLUInt16ushort_
F_INTintINT NOT NULLInt32
F_INT_NULLint?INT NULLInt32
F_UINTuintINT UNSIGNED NOT NULLUInt32uint_
F_UINT_NULLuint?INT UNSIGNED NULLUInt32uint_
F_LONGlongBIGINT NOT NULLInt64
F_LONG_NULLlong?BIGINT NULLInt64
F_ULONGulongBIGINT UNSIGNED NOT NULLUInt64ulong_
F_ULONG_NULLulong?BIGINT UNSIGNED NULLUInt64ulong_
F_FLOATfloatFLOAT NOT NULLSingle 极值溢出
F_FLOAT_NULLfloat?FLOAT NULLSingle 极值溢出
F_DOUBLEdoubleDOUBLE NOT NULLDouble
F_DOUBLE_NULLdouble?DOUBLE NULLDouble
F_DECIMALdecimalDECIMAL NOT NULLDecimal 极值溢出
F_DECIMAL_NULLdecimal?DECIMAL NULLDecimal 极值溢出
F_CHARcharCHARACTER NOT NULLString 中文报错
F_CHAR_NULLchar?CHARACTER NULLString 中文报错
F_STRINGstringVARCHAR(50) NOT NULLString
F_STRING_NULLstringVARCHAR(50) NULLString
F_DATETIMEDateTimeDATETIME NOT NULLDateTime
F_DATETIME_NULLDateTime?DATETIME NULLDateTime
三、 C# vs MSSQL：
艺映AI
艺映AI – 免费AI视频创作工具
62 查看详情
C#MSSQL
字段名类型库类型GetFieldType(#)转换备注
F_BOOLboolbit NOT NULLBoolean
F_BOOL_NULLbool?bit NULLBoolean
F_SBYTEsbytesmallint NOT NULLInt16sbyte_short
F_SBYTE_NULLsbyte?smallint NULLInt16sbyte_short
F_BYTEbytetinyint NOT NUL;Byte
F_BYTE_NULLbyte?tinyint NULLByte
F_SHORTshortsmallint NOT NULLInt16
F_SHORT_NULLshort?smallint NULLInt16
F_USHORTushortint NOT NULLInt32ushort_int
F_USHORT_NULLushort?int NULLInt32ushort_int
F_INTintint NOT NULLInt32
F_INT_NULLint?int NULLInt32
F_UINTuintbigint NOT NULLInt64uint_long
F_UINT_NULLuint?bigint NULLInt64uint_long
F_LONGlongbigint NOT NULLInt64
F_LONG_NULLlong?bigint NULLInt64
F_ULONGulongreal NOT NULLSingleulong_float
F_ULONG_NULLulong?real NULLSingleulong_float
F_FLOATfloatreal NOT NULLSingle
F_FLOAT_NULLfloat?real NULLSingle
F_DOUBLEdoublefloat NOT NULLDouble
F_DOUBLE_NULLdouble?float NULLDouble
F_DECIMALdecimaldecimal NOT NULLDecimal 极值溢出
F_DECIMAL_NULLdecimal?decimal NULLDecimal 极值溢出
F_CHARcharchar(1) NOT NULLString
F_CHAR_NULLchar?char(1) NULLString
F_STRINGstringvarchar(50) NOT NULLF_STRING:
F_STRING_NULLstringvarchar(50) NULLString
F_DATETIMEDateTimedatetime NOT NULLDateTime
F_DATETIME_NULLDateTime?datetime NULLDateTime
四、C# vs Oracle：
C#Oracle
字段名类型库类型GetFieldType(#)转换备注
F_BOOLboolCHAR(1) NOT NULLStringbool_string
F_BOOL_NULLbool?CHAR(1)Stringbool_string
F_SBYTEsbyteNUMBER(3) NOT NULLInt16sbyte_short
F_SBYTE_NULLsbyte?NUMBER(3)Int16sbyte_short
F_BYTEbyteNUMBER(3) NOT NULLInt16byte_short
F_BYTE_NULLbyte?NUMBER(3)Int16byte_short
F_SHORTshortNUMBER(5) NOT NULLInt32short_int
F_SHORT_NULLshort?NUMBER(5)Int32short_int
F_USHORTushortNUMBER(5) NOT NULLInt32ushort_int
F_USHORT_NULLushort?NUMBER(5)Int32ushort_int
F_INTintNUMBER(10) NOT NULLInt64int_long
F_INT_NULLint?NUMBER(10)Int64int_long
F_UINTuintNUMBER(10) NOT NULLInt64uint_long
F_UINT_NULLuint?NUMBER(10)Int64uint_long
F_LONGlongNUMBER(19) NOT NULLDecimallong_decimal
F_LONG_NULLlong?NUMBER(19)Decimallong_decimal
F_ULONGulongNUMBER(19) NOT NULLDecimalulong_decimal
F_ULONG_NULLulong?NUMBER(19)Decimalulong_decimal
F_FLOATfloatBINARY_FLOAT NOT NULLSingle
F_FLOAT_NULLfloat?BINARY_FLOATSingle
F_DOUBLEdoubleBINARY_DOUBLE NOT NULLDouble 极值溢出
F_DOUBLE_NULLdouble?BINARY_DOUBLEDouble 极值溢出
F_DECIMALdecimalDECIMAL(33,3) NOT NULLDecimal
F_DECIMAL_NULLdecimal?DECIMAL(33,3)Decimal
F_CHARcharCHAR(1) NOT NULLString
F_CHAR_NULLchar?CHAR(1)String
F_STRINGstringVARCHAR(50) NOT NULLString 不允许空字符
F_STRING_NULLstringVARCHAR(50)String 不允许空字符
F_DATETIMEDateTimeTIMESTAMP NOT NULLDateTime 大值读取报错
F_DATETIME_NULLDateTime?TIMESTAMPDateTime 大值读取报
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/536985.html
微信扫一扫 
支付宝扫一扫 
