Skip to content

column-ddl-type-codes.md

Latest commit

 

History

History
84 lines (78 loc) · 3.78 KB

column-ddl-type-codes.md

File metadata and controls

84 lines (78 loc) · 3.78 KB
title Column and DDL Type Codes
summary Learn the column and DDL type codes.
category reference
aliases
/docs/dev/reference/tools/ticdc/column-ddl-type/

Column and DDL Type Codes

The column and DDL type codes are encodings defined by TiCDC Open Protocol. The column type code identifies the column data type in Row Changed Events. The DDL type code identifies the DDL statement type in DDL Events.

Column Type Code

Type Code Output example Note
Decimal 0 {"t":0,"v":"129012.1230000"}
Tiny/Bool 1 {"t":1,"v":1}
Short 2 {"t":2,"v":1}
Long 3 {"t":3,"v":123}
Float 4 {"t":4,"v":153.123}
Double 5 {"t":5,"v":153.123}
Null 6 {"t":6,"v":null}
Timestamp 7 {"t":7,"v":"1973-12-30 15:30:00"}
Longlong 8 {"t":8,"v":123}
Int24 9 {"t":9,"v":123}
Date 10 {"t":10,"v":"2000-01-01"}
Duration 11 {"t":11,"v":"23:59:59"}
Datetime 12 {"t":12,"v":"2015-12-20 23:58:58"}
Year 13 {"t":13,"v":1970}
New Date 14 {"t":14,"v":"2000-01-01"}
Varchar 15 {"t":15,"v":"test"} The value is encoded in UTF-8.
Bit 16 {"t":16,"v":81}
JSON 245 {"t":245,"v":"{\"key1\": \"value1\"}"}
New Decimal 246 {"t":246,"v":"129012.1230000"}
Enum 247 {"t":247,"v":1}
Set 248 {"t":248,"v":3}
Tiny Blob 249 {"t":249,"v":"5rWL6K+VdGV4dA=="} The value is encoded in Base64.
Medium Blob 250 {"t":250,"v":"5rWL6K+VdGV4dA=="} The value is encoded in Base64.
Long Blob 251 {"t":251,"v":"5rWL6K+VdGV4dA=="} The value is encoded in Base64.
Blob 252 {"t":252,"v":"5rWL6K+VdGV4dA=="} The value is encoded in Base64.
Var String 253 {"t":253,"v":"test"} The value is encoded in UTF-8.
String 254 {"t":254,"v":"test"} The value is encoded in UTF-8.
Geometry 255 Unsupported type

DDL Type Code

Type Code
Create Schema 1
Drop Schema 2
Create Table 3
Drop Table 4
Add Column 5
Drop Column 6
Add Index 7
Drop Index 8
Add Foreign Key 9
Drop Foreign Key 10
Truncate Table 11
Modify Column 12
Rebase Auto ID 13
Rename Table 14
Set Default Value 15
Shard RowID 16
Modify Table Comment 17
Rename Index 18
Add Table Partition 19
Drop Table Partition 20
Create View 21
Modify Table Charset And Collate 22
Truncate Table Partition 23
Drop View 24
Recover Table 25
Modify Schema Charset And Collate 26
Lock Table 27
Unlock Table 28
Repair Table 29
Set TiFlash Replica 30
Update TiFlash Replica Status 31
Add Primary Key 32
Drop Primary Key 33
Create Sequence 34
Alter Sequence 35
Drop Sequence 36
⚡