Collation: binary()

in unittest/scripts/auto/js_shell/validation/sql_show_column_type_info_norecord.js [245:507]
242 lines of code
1 McCabe index (conditional complexity)

Collation: binary (63)
Length:    10
Decimals:  0
Flags:     BINARY

Field 18
Name:      `year`
Org_name:  `year`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      UInteger
DbType:    TINY
Collation: binary (63)
Length:    4
Decimals:  0
Flags:     NOT_NULL UNSIGNED NUM

Field 19
Name:      `tinyblob`
Org_name:  `tinyblob`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Bytes
DbType:    BLOB
Collation: binary (63)
Length:    255
Decimals:  0
Flags:     BLOB BINARY

Field 20
Name:      `tinytext`
Org_name:  `tinytext`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      String
DbType:    BLOB
Collation: utf8mb4_0900_ai_ci (255)
Length:    255
Decimals:  0
Flags:     BLOB

Field 21
Name:      `blob`
Org_name:  `blob`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Bytes
DbType:    BLOB
Collation: binary (63)
Length:    65535
Decimals:  0
Flags:     BLOB BINARY

Field 22
Name:      `text`
Org_name:  `text`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      String
DbType:    BLOB
Collation: utf8mb4_0900_ai_ci (255)
Length:    65535
Decimals:  0
Flags:     BLOB

Field 23
Name:      `mediumblob`
Org_name:  `mediumblob`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Bytes
DbType:    BLOB
Collation: binary (63)
Length:    16777215
Decimals:  0
Flags:     BLOB BINARY

Field 24
Name:      `mediumtext`
Org_name:  `mediumtext`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      String
DbType:    BLOB
Collation: utf8mb4_0900_ai_ci (255)
Length:    16777215
Decimals:  0
Flags:     BLOB

Field 25
Name:      `longblob`
Org_name:  `longblob`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Bytes
DbType:    BLOB
Collation: binary (63)
Length:    4294967295
Decimals:  0
Flags:     BLOB BINARY

Field 26
Name:      `longtext`
Org_name:  `longtext`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      String
DbType:    BLOB
Collation: utf8mb4_0900_ai_ci (255)
Length:    4294967295
Decimals:  0
Flags:     BLOB

Field 27
Name:      `enum`
Org_name:  `enum`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Enum
DbType:    STRING
Collation: utf8mb4_0900_ai_ci (255)
Length:    0
Decimals:  0
Flags:     ENUM

Field 28
Name:      `set`
Org_name:  `set`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Set
DbType:    STRING
Collation: utf8mb4_0900_ai_ci (255)
Length:    0
Decimals:  0
Flags:     SET

Field 29
Name:      `json`
Org_name:  `json`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Json
DbType:    JSON
Collation: binary (63)
Length:    4294967295
Decimals:  0
Flags:     BLOB BINARY

Field 30
Name:      `geometry`
Org_name:  `geometry`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Geometry
DbType:    GEOMETRY
Collation: binary (63)
Length:    0
Decimals:  0
Flags:     BLOB BINARY

Field 31
Name:      `bool`
Org_name:  `bool`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Integer
DbType:    TINY
Collation: binary (63)
Length:    1
Decimals:  0
Flags:     NUM

Field 32
Name:      `char`
Org_name:  `char`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      String
DbType:    VAR_STRING
Collation: utf8mb4_0900_ai_ci (255)
Length:    40
Decimals:  0
Flags:

Field 33
Name:      `varchar`
Org_name:  `varchar`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      String
DbType:    VAR_STRING
Collation: utf8mb4_0900_ai_ci (255)
Length:    80
Decimals:  0
Flags:

Field 34
Name:      `binary`
Org_name:  `binary`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Bytes
DbType:    VAR_STRING
Collation: binary (63)
Length:    20
Decimals:  0
Flags:     BINARY

Field 35
Name:      `varbinary`
Org_name:  `varbinary`
Catalog:   `def`
Database:  `scti_test`
Table:     `t`
Org_table: `t`
Type:      Bytes
DbType:    VAR_STRING
Collation: binary (63)
Length:    20
Decimals:  0
Flags:     BINARY

0

//@<OUT> Column type info enabled X JSON
{
    "warning": "Using a password on the command line interface can be insecure.\n"
}