Таблица отличий содержимого RDB$TYPES Firebird и InterBase

синим помечены дубликаты
красным - несоответствия
то же самое в xlsx.

Firebird 2.5   InterBase XE  
       
RDB$FIELD_NAME RDB$TYPE   RDB$TYPE_NAME RDB$FIELD_NAME RDB$TYPE   RDB$TYPE_NAME
RDB$FIELD_TYPE 14   TEXT RDB$FIELD_TYPE 14   TEXT
RDB$FIELD_TYPE 7   SHORT RDB$FIELD_TYPE 7   SHORT
RDB$FIELD_TYPE 8   LONG RDB$FIELD_TYPE 8   LONG
RDB$FIELD_TYPE 9   QUAD RDB$FIELD_TYPE 9   QUAD
RDB$FIELD_TYPE 10   FLOAT RDB$FIELD_TYPE 10   FLOAT
RDB$FIELD_TYPE 27   DOUBLE RDB$FIELD_TYPE 27   DOUBLE
RDB$FIELD_TYPE 35   TIMESTAMP RDB$FIELD_TYPE 35   TIMESTAMP
RDB$FIELD_TYPE 37   VARYING RDB$FIELD_TYPE 37   VARYING
RDB$FIELD_TYPE 261   BLOB RDB$FIELD_TYPE 261   BLOB
RDB$FIELD_TYPE 40   CSTRING RDB$FIELD_TYPE 40   CSTRING
RDB$FIELD_TYPE 45   BLOB_ID RDB$FIELD_TYPE 45   BLOB_ID
RDB$FIELD_TYPE 12   DATE RDB$FIELD_TYPE 12   DATE
RDB$FIELD_TYPE 13   TIME RDB$FIELD_TYPE 13   TIME
RDB$FIELD_TYPE 16   INT64  
        RDB$FIELD_TYPE 17   BOOLEAN
RDB$FIELD_SUB_TYPE 0   BINARY  
RDB$FIELD_SUB_TYPE 1   TEXT RDB$FIELD_SUB_TYPE 1   TEXT
RDB$FIELD_SUB_TYPE 2   BLR RDB$FIELD_SUB_TYPE 2   BLR
RDB$FIELD_SUB_TYPE 3   ACL RDB$FIELD_SUB_TYPE 3   ACL
RDB$FIELD_SUB_TYPE 4   RANGES RDB$FIELD_SUB_TYPE 4   RANGES
RDB$FIELD_SUB_TYPE 5   SUMMARY RDB$FIELD_SUB_TYPE 5   SUMMARY
RDB$FIELD_SUB_TYPE 6   FORMAT RDB$FIELD_SUB_TYPE 6   FORMAT
RDB$FIELD_SUB_TYPE 7   TRANSACTION_DESCRIPTION RDB$FIELD_SUB_TYPE 7   TRANSACTION_DESCRIPTION
RDB$FIELD_SUB_TYPE 8   EXTERNAL_FILE_DESCRIPTION RDB$FIELD_SUB_TYPE 8   EXTERNAL_FILE_DESCRIPTION
RDB$FIELD_SUB_TYPE 9   DEBUG_INFORMATION  
RDB$FUNCTION_TYPE 0   VALUE RDB$FUNCTION_TYPE 0   VALUE
RDB$FUNCTION_TYPE 1   BOOLEAN RDB$FUNCTION_TYPE 1   BOOLEAN
RDB$MECHANISM 0   BY_VALUE RDB$MECHANISM 0   BY_VALUE
RDB$MECHANISM 1   BY_REFERENCE RDB$MECHANISM 1   BY_REFERENCE
RDB$MECHANISM 2   BY_VMS_DESCRIPTOR RDB$MECHANISM 2   BY_VMS_DESCRIPTOR
RDB$MECHANISM 3   BY_ISC_DESCRIPTOR RDB$MECHANISM 3   BY_ISC_DESCRIPTOR
RDB$MECHANISM 4   BY_SCALAR_ARRAY_DESCRIPTOR RDB$MECHANISM 4   BY_SCALAR_ARRAY_DESCRIPTOR
RDB$MECHANISM 5   BY_REFERENCE_WITH_NULL  
RDB$TRIGGER_TYPE 1   PRE_STORE RDB$TRIGGER_TYPE 1   PRE_STORE
RDB$TRIGGER_TYPE 2   POST_STORE RDB$TRIGGER_TYPE 2   POST_STORE
RDB$TRIGGER_TYPE 3   PRE_MODIFY RDB$TRIGGER_TYPE 3   PRE_MODIFY
RDB$TRIGGER_TYPE 4   POST_MODIFY RDB$TRIGGER_TYPE 4   POST_MODIFY
RDB$TRIGGER_TYPE 5   PRE_ERASE RDB$TRIGGER_TYPE 5   PRE_ERASE
RDB$TRIGGER_TYPE 6   POST_ERASE RDB$TRIGGER_TYPE 6   POST_ERASE
RDB$TRIGGER_TYPE 8192   CONNECT  
RDB$TRIGGER_TYPE 8193   DISCONNECT  
RDB$TRIGGER_TYPE 8194   TRANSACTION_START  
RDB$TRIGGER_TYPE 8195   TRANSACTION_COMMIT  
RDB$TRIGGER_TYPE 8196   TRANSACTION_ROLLBACK  
RDB$OBJECT_TYPE 0   RELATION RDB$OBJECT_TYPE 0   RELATION
RDB$OBJECT_TYPE 1   VIEW RDB$OBJECT_TYPE 1   VIEW
RDB$OBJECT_TYPE 2   TRIGGER RDB$OBJECT_TYPE 2   TRIGGER
RDB$OBJECT_TYPE 3   COMPUTED_FIELD RDB$OBJECT_TYPE 3   COMPUTED_FIELD
RDB$OBJECT_TYPE 4   VALIDATION RDB$OBJECT_TYPE 4   VALIDATION
RDB$OBJECT_TYPE 5   PROCEDURE RDB$OBJECT_TYPE 5   PROCEDURE
RDB$OBJECT_TYPE 6   EXPRESSION_INDEX RDB$OBJECT_TYPE 6   EXPRESSION_INDEX
RDB$OBJECT_TYPE 7   EXCEPTION RDB$OBJECT_TYPE 7   EXCEPTION
RDB$OBJECT_TYPE 8   USER RDB$OBJECT_TYPE 8   USER
RDB$OBJECT_TYPE 9   FIELD RDB$OBJECT_TYPE 9   FIELD
RDB$OBJECT_TYPE 10   INDEX RDB$OBJECT_TYPE 10   INDEX
        RDB$OBJECT_TYPE 11   GENERATOR
RDB$OBJECT_TYPE 12   USER_GROUP RDB$OBJECT_TYPE 12   USER_GROUP
RDB$OBJECT_TYPE 13   ROLE RDB$OBJECT_TYPE 13   ROLE
RDB$OBJECT_TYPE 14   GENERATOR RDB$OBJECT_TYPE 14   UDF
RDB$OBJECT_TYPE 15   UDF RDB$OBJECT_TYPE 15   ENCRYPTION
RDB$OBJECT_TYPE 16   BLOB_FILTER  
RDB$OBJECT_TYPE 17   COLLATION  
RDB$TRANSACTION_STATE 1   LIMBO RDB$TRANSACTION_STATE 1   LIMBO
RDB$TRANSACTION_STATE 2   COMMITTED RDB$TRANSACTION_STATE 2   COMMITTED
RDB$TRANSACTION_STATE 3   ROLLED_BACK RDB$TRANSACTION_STATE 3   ROLLED_BACK
RDB$SYSTEM_FLAG 0   USER  
RDB$SYSTEM_FLAG 1   SYSTEM  
RDB$SYSTEM_FLAG 2   QLI  
RDB$SYSTEM_FLAG 3   CHECK_CONSTRAINT  
RDB$SYSTEM_FLAG 4   REFERENTIAL_CONSTRAINT  
RDB$SYSTEM_FLAG 5   VIEW_CHECK  
RDB$RELATION_TYPE 0   PERSISTENT  
RDB$RELATION_TYPE 1   VIEW  
RDB$RELATION_TYPE 2   EXTERNAL  
RDB$RELATION_TYPE 3   VIRTUAL  
RDB$RELATION_TYPE 4   GLOBAL_TEMPORARY_PRESERVE  
RDB$RELATION_TYPE 5   GLOBAL_TEMPORARY_DELETE  
RDB$PROCEDURE_TYPE 0   LEGACY  
RDB$PROCEDURE_TYPE 1   SELECTABLE  
RDB$PROCEDURE_TYPE 2   EXECUTABLE  
RDB$PARAMETER_MECHANISM 0   NORMAL  
RDB$PARAMETER_MECHANISM 1   TYPE OF  
MON$STATE 0   IDLE  
MON$STATE 1   ACTIVE  
MON$STATE 2   STALLED  
MON$SHUTDOWN_MODE 0   ONLINE  
MON$SHUTDOWN_MODE 1   MULTI_USER_SHUTDOWN  
MON$SHUTDOWN_MODE 2   SINGLE_USER_SHUTDOWN  
MON$SHUTDOWN_MODE 3   FULL_SHUTDOWN  
MON$ISOLATION_MODE 0   CONSISTENCY  
MON$ISOLATION_MODE 1   CONCURRENCY  
MON$ISOLATION_MODE 2   READ_COMMITTED_VERSION  
MON$ISOLATION_MODE 3   READ_COMMITTED_NO_VERSION  
MON$BACKUP_STATE 0   NORMAL  
MON$BACKUP_STATE 1   STALLED  
MON$BACKUP_STATE 2   MERGE  
MON$STAT_GROUP 0   DATABASE  
MON$STAT_GROUP 1   ATTACHMENT  
MON$STAT_GROUP 2   TRANSACTION  
MON$STAT_GROUP 3   STATEMENT  
MON$STAT_GROUP 4   CALL  
RDB$CHARACTER_SET_NAME 0   NONE RDB$CHARACTER_SET_NAME 0   NONE
RDB$CHARACTER_SET_NAME 1   OCTETS RDB$CHARACTER_SET_NAME 1   OCTETS
RDB$CHARACTER_SET_NAME 1   BINARY RDB$CHARACTER_SET_NAME 1   BINARY
RDB$CHARACTER_SET_NAME 2   ASCII RDB$CHARACTER_SET_NAME 2   ASCII
RDB$CHARACTER_SET_NAME 2   USASCII RDB$CHARACTER_SET_NAME 2   USASCII
RDB$CHARACTER_SET_NAME 2   ASCII7 RDB$CHARACTER_SET_NAME 2   ASCII7
RDB$CHARACTER_SET_NAME 3   UNICODE_FSS RDB$CHARACTER_SET_NAME 3   UNICODE_FSS
RDB$CHARACTER_SET_NAME 3   UTF_FSS RDB$CHARACTER_SET_NAME 3   UTF_FSS
RDB$CHARACTER_SET_NAME 3   SQL_TEXT RDB$CHARACTER_SET_NAME 3   SQL_TEXT
RDB$CHARACTER_SET_NAME 4   UTF8  
RDB$CHARACTER_SET_NAME 4   UTF-8  
        RDB$CHARACTER_SET_NAME 59   UTF8
        RDB$CHARACTER_SET_NAME 59   UTF_8
RDB$CHARACTER_SET_NAME 5   SJIS_0208 RDB$CHARACTER_SET_NAME 5   SJIS_0208
RDB$CHARACTER_SET_NAME 5   SJIS RDB$CHARACTER_SET_NAME 5   SJIS
RDB$CHARACTER_SET_NAME 6   EUCJ_0208 RDB$CHARACTER_SET_NAME 6   EUCJ_0208
RDB$CHARACTER_SET_NAME 6   EUCJ RDB$CHARACTER_SET_NAME 6   EUCJ
        RDB$CHARACTER_SET_NAME 8   UNICODE_BE
        RDB$CHARACTER_SET_NAME 8   UCS2BE
RDB$CHARACTER_SET_NAME 9   DOS_737        
RDB$CHARACTER_SET_NAME 9   DOS737        
RDB$CHARACTER_SET_NAME 10   DOS437 RDB$CHARACTER_SET_NAME 10   DOS437
RDB$CHARACTER_SET_NAME 10   DOS_437 RDB$CHARACTER_SET_NAME 10   DOS_437
RDB$CHARACTER_SET_NAME 11   DOS850 RDB$CHARACTER_SET_NAME 11   DOS850
RDB$CHARACTER_SET_NAME 11   DOS_850 RDB$CHARACTER_SET_NAME 11   DOS_850
RDB$CHARACTER_SET_NAME 12   DOS865 RDB$CHARACTER_SET_NAME 12   DOS865
RDB$CHARACTER_SET_NAME 12   DOS_865 RDB$CHARACTER_SET_NAME 12   DOS_865
RDB$CHARACTER_SET_NAME 13   DOS860 RDB$CHARACTER_SET_NAME 13   DOS860
RDB$CHARACTER_SET_NAME 13   DOS_860 RDB$CHARACTER_SET_NAME 13   DOS_860
RDB$CHARACTER_SET_NAME 14   DOS863 RDB$CHARACTER_SET_NAME 14   DOS863
RDB$CHARACTER_SET_NAME 14   DOS_863 RDB$CHARACTER_SET_NAME 14   DOS_863
RDB$CHARACTER_SET_NAME 15   DOS775        
RDB$CHARACTER_SET_NAME 15   DOS_775        
RDB$CHARACTER_SET_NAME 16   DOS858        
RDB$CHARACTER_SET_NAME 16   DOS_858        
RDB$CHARACTER_SET_NAME 17   DOS862        
RDB$CHARACTER_SET_NAME 17   DOS_862        
RDB$CHARACTER_SET_NAME 18   DOS864        
RDB$CHARACTER_SET_NAME 18   DOS_864        
RDB$CHARACTER_SET_NAME 19   NEXT RDB$CHARACTER_SET_NAME 19   NEXT
RDB$CHARACTER_SET_NAME 21   ISO8859_1 RDB$CHARACTER_SET_NAME 21   ISO8859_1
RDB$CHARACTER_SET_NAME 21   ISO8859_1 RDB$CHARACTER_SET_NAME 21   ISO_8859_1
RDB$CHARACTER_SET_NAME 21   ISO88591 RDB$CHARACTER_SET_NAME 21   ISO88591
RDB$CHARACTER_SET_NAME 21   LATIN1 RDB$CHARACTER_SET_NAME 21   LATIN1
RDB$CHARACTER_SET_NAME 21   ANSI RDB$CHARACTER_SET_NAME 21   ANSI
RDB$CHARACTER_SET_NAME 22   ISO8859_2 RDB$CHARACTER_SET_NAME 22   ISO8859_2
RDB$CHARACTER_SET_NAME 22   ISO8859_2 RDB$CHARACTER_SET_NAME 22   ISO_8859_2
RDB$CHARACTER_SET_NAME 22   ISO88592 RDB$CHARACTER_SET_NAME 22   ISO88592
RDB$CHARACTER_SET_NAME 22   LATIN2 RDB$CHARACTER_SET_NAME 22   LATIN2
RDB$CHARACTER_SET_NAME 22   ISO-8859-2 RDB$CHARACTER_SET_NAME 22   ISO-8859-2
RDB$CHARACTER_SET_NAME 23   ISO8859_3  
RDB$CHARACTER_SET_NAME 23   ISO8859_3  
RDB$CHARACTER_SET_NAME 23   ISO88593  
RDB$CHARACTER_SET_NAME 23   LATIN3  
RDB$CHARACTER_SET_NAME 23   ISO-8859-3  
RDB$CHARACTER_SET_NAME 34   ISO8859_4  
RDB$CHARACTER_SET_NAME 34   ISO8859_4        
RDB$CHARACTER_SET_NAME 34   ISO88594        
RDB$CHARACTER_SET_NAME 34   LATIN4        
RDB$CHARACTER_SET_NAME 34   ISO-8859-4        
RDB$CHARACTER_SET_NAME 35   ISO8859_5  
RDB$CHARACTER_SET_NAME 35   ISO8859_5  
RDB$CHARACTER_SET_NAME 35   ISO88595  
RDB$CHARACTER_SET_NAME 35   ISO-8859-5  
RDB$CHARACTER_SET_NAME 36   ISO8859_6  
RDB$CHARACTER_SET_NAME 36   ISO8859_6  
RDB$CHARACTER_SET_NAME 36   ISO88596  
RDB$CHARACTER_SET_NAME 36   ISO-8859-6  
RDB$CHARACTER_SET_NAME 37   ISO8859_7  
RDB$CHARACTER_SET_NAME 37   ISO8859_7  
RDB$CHARACTER_SET_NAME 37   ISO88597  
RDB$CHARACTER_SET_NAME 37   ISO-8859-7  
RDB$CHARACTER_SET_NAME 38   ISO8859_8  
RDB$CHARACTER_SET_NAME 38   ISO8859_8  
RDB$CHARACTER_SET_NAME 38   ISO88598  
RDB$CHARACTER_SET_NAME 38   ISO-8859-8  
RDB$CHARACTER_SET_NAME 39   ISO8859_9 RDB$CHARACTER_SET_NAME 39   ISO8859_15
RDB$CHARACTER_SET_NAME 39   ISO8859_9 RDB$CHARACTER_SET_NAME 39   ISO_8859_15
RDB$CHARACTER_SET_NAME 39   ISO88599 RDB$CHARACTER_SET_NAME 39   ISO885915
RDB$CHARACTER_SET_NAME 39   LATIN5 RDB$CHARACTER_SET_NAME 39   LATIN9
RDB$CHARACTER_SET_NAME 39   ISO-8859-9 RDB$CHARACTER_SET_NAME 39   ISO-8859-15
RDB$CHARACTER_SET_NAME 40   ISO8859_13  
RDB$CHARACTER_SET_NAME 40   ISO8859_13  
RDB$CHARACTER_SET_NAME 40   ISO885913  
RDB$CHARACTER_SET_NAME 40   LATIN7  
RDB$CHARACTER_SET_NAME 40   ISO-8859-13  
RDB$CHARACTER_SET_NAME 44   KSC5601 RDB$CHARACTER_SET_NAME 44   KSC5601
RDB$CHARACTER_SET_NAME 44   KSC_5601 RDB$CHARACTER_SET_NAME 44   KSC_5601
RDB$CHARACTER_SET_NAME 44   DOS_949 RDB$CHARACTER_SET_NAME 44   DOS_949
RDB$CHARACTER_SET_NAME 44   WIN_949 RDB$CHARACTER_SET_NAME 44   WIN_949
RDB$CHARACTER_SET_NAME 45   DOS852 RDB$CHARACTER_SET_NAME 45   DOS852
RDB$CHARACTER_SET_NAME 45   DOS_852 RDB$CHARACTER_SET_NAME 45   DOS_852
RDB$CHARACTER_SET_NAME 46   DOS857 RDB$CHARACTER_SET_NAME 46   DOS857
RDB$CHARACTER_SET_NAME 46   DOS_857 RDB$CHARACTER_SET_NAME 46   DOS_857
RDB$CHARACTER_SET_NAME 47   DOS861 RDB$CHARACTER_SET_NAME 47   DOS861
RDB$CHARACTER_SET_NAME 47   DOS_861  
RDB$CHARACTER_SET_NAME 48   DOS866  
RDB$CHARACTER_SET_NAME 48   DOS_866  
RDB$CHARACTER_SET_NAME 49   DOS869  
RDB$CHARACTER_SET_NAME 49   DOS_869  
RDB$CHARACTER_SET_NAME 50   CYRL RDB$CHARACTER_SET_NAME 50   CYRL
RDB$CHARACTER_SET_NAME 51   WIN1250 RDB$CHARACTER_SET_NAME 51   WIN1250
RDB$CHARACTER_SET_NAME 51   WIN_1250 RDB$CHARACTER_SET_NAME 51   WIN_1250
RDB$CHARACTER_SET_NAME 52   WIN1251 RDB$CHARACTER_SET_NAME 52   WIN1251
RDB$CHARACTER_SET_NAME 52   WIN_1251 RDB$CHARACTER_SET_NAME 52   WIN_1251
RDB$CHARACTER_SET_NAME 53   WIN_1252 RDB$CHARACTER_SET_NAME 53   WIN1252
RDB$CHARACTER_SET_NAME 53   WIN1252 RDB$CHARACTER_SET_NAME 53   WIN_1252
RDB$CHARACTER_SET_NAME 54   WIN1253 RDB$CHARACTER_SET_NAME 54   WIN1253
RDB$CHARACTER_SET_NAME 54   WIN_1253 RDB$CHARACTER_SET_NAME 54   WIN_1253
RDB$CHARACTER_SET_NAME 55   WIN1254 RDB$CHARACTER_SET_NAME 55   WIN1254
RDB$CHARACTER_SET_NAME 55   WIN_1254 RDB$CHARACTER_SET_NAME 55   WIN_1254
RDB$CHARACTER_SET_NAME 56   BIG5 RDB$CHARACTER_SET_NAME 56   BIG5
RDB$CHARACTER_SET_NAME 56   BIG_5 RDB$CHARACTER_SET_NAME 56   BIG_5
RDB$CHARACTER_SET_NAME 56   DOS_950 RDB$CHARACTER_SET_NAME 56   DOS_950
RDB$CHARACTER_SET_NAME 56   WIN_950 RDB$CHARACTER_SET_NAME 56   WIN_950
RDB$CHARACTER_SET_NAME 57   GB2312 RDB$CHARACTER_SET_NAME 57   GB2312
RDB$CHARACTER_SET_NAME 57   GB_2312 RDB$CHARACTER_SET_NAME 57   GB_2312
RDB$CHARACTER_SET_NAME 57   DOS_936 RDB$CHARACTER_SET_NAME 57   DOS_936
RDB$CHARACTER_SET_NAME 57   WIN_936 RDB$CHARACTER_SET_NAME 57   WIN_936
RDB$CHARACTER_SET_NAME 58   WIN_1255  
RDB$CHARACTER_SET_NAME 59   WIN_1256  
RDB$CHARACTER_SET_NAME 58   WIN1255 RDB$CHARACTER_SET_NAME 58   KOI8R
RDB$CHARACTER_SET_NAME 59   WIN1256  
RDB$CHARACTER_SET_NAME 60   WIN1257  
RDB$CHARACTER_SET_NAME 60   WIN_1257  
RDB$CHARACTER_SET_NAME 63   KOI8R  
RDB$CHARACTER_SET_NAME 64   KOI8U RDB$CHARACTER_SET_NAME 64   UNICODE_LE
        RDB$CHARACTER_SET_NAME 64   UCS2LE
RDB$CHARACTER_SET_NAME 65   WIN1258  
RDB$CHARACTER_SET_NAME 65   WIN_1258  
RDB$CHARACTER_SET_NAME 66   TIS620  
RDB$CHARACTER_SET_NAME 67   GBK  
RDB$CHARACTER_SET_NAME 68   CP943C  
RDB$CHARACTER_SET_NAME 69   GB18030  
  RDB$CHARACTER_SET_NAME 126   BASE64

Подпишитесь на новости Firebird в России

Подписаться