大小写敏感性(Case sensitivity)是指使用大写字母、小写字母造成不同效果的情况。
例如,对于大小写敏感(case_insensitive=0)的String
字符串类型来说,字符串ByteHouse
和字符串bytehouse
存入到数据库后的值是不相等的。
ByteHouse 云数仓版所有支持的数据类型的大小写敏感性如下表,case_insensitive=0 表示大小写敏感。
数据类型 | 大小写敏感性 (case_sensitive) |
---|---|
AggregateFunction | 0 |
Array | 0 |
Base64ToBinary | 1 |
BIGINT | 1 |
BIGINT SIGNED | 1 |
BIGINT UNSIGNED | 1 |
BINARY | 1 |
BINARY LARGE OBJECT | 1 |
BINARY VARYING | 1 |
BitMap64 | 0 |
BLOB | 1 |
Bool | 1 |
bool | 1 |
boolean | 1 |
BYTE | 1 |
BYTEA | 1 |
CHAR | 1 |
CHAR LARGE OBJECT | 1 |
CHAR VARYING | 1 |
CHARACTER | 1 |
CHARACTER LARGE OBJECT | 1 |
CHARACTER VARYING | 1 |
CLOB | 1 |
Date | 1 |
Date32 | 1 |
DateTime | 1 |
DateTime32 | 1 |
DateTime64 | 1 |
DateTimeWithoutTz | 1 |
DEC | 1 |
Decimal | 1 |
Decimal128 | 1 |
Decimal256 | 1 |
Decimal32 | 1 |
Decimal64 | 1 |
DOUBLE | 1 |
DOUBLE PRECISION | 1 |
Enum | 1 |
ENUM | 1 |
Enum16 | 0 |
Enum8 | 0 |
FIXED | 1 |
FixedString | 0 |
FLOAT | 1 |
Float32 | 0 |
Float64 | 0 |
HllSketchBinary | 1 |
INET4 | 1 |
INET6 | 1 |
INT | 1 |
INT SIGNED | 1 |
INT UNSIGNED | 1 |
INT1 | 1 |
INT1 SIGNED | 1 |
INT1 UNSIGNED | 1 |
Int128 | 0 |
Int16 | 0 |
Int256 | 0 |
Int32 | 0 |
Int64 | 0 |
Int8 | 0 |
INTEGER | 1 |
INTEGER SIGNED | 1 |
INTEGER UNSIGNED | 1 |
IntervalDay | 0 |
IntervalHour | 0 |
IntervalMinute | 0 |
IntervalMonth | 0 |
IntervalQuarter | 0 |
IntervalSecond | 0 |
IntervalWeek | 0 |
IntervalYear | 0 |
IPv4 | 0 |
IPv6 | 0 |
LONGBLOB | 1 |
LONGTEXT | 1 |
LowCardinality | 0 |
Map | 0 |
MEDIUMBLOB | 1 |
MEDIUMINT | 1 |
MEDIUMINT SIGNED | 1 |
MEDIUMINT UNSIGNED | 1 |
MEDIUMTEXT | 1 |
MultiPolygon | 0 |
NATIONAL CHAR | 1 |
NATIONAL CHAR VARYING | 1 |
NATIONAL CHARACTER | 1 |
NATIONAL CHARACTER LARGE OBJECT | 1 |
NATIONAL CHARACTER VARYING | 1 |
NCHAR | 1 |
NCHAR LARGE OBJECT | 1 |
NCHAR VARYING | 1 |
Nested | 0 |
Nothing | 0 |
Nullable | 0 |
NUMERIC | 1 |
NVARCHAR | 1 |
Point | 0 |
Polygon | 0 |
REAL | 1 |
Ring | 0 |
Set | 0 |
SimpleAggregateFunction | 0 |
SINGLE | 1 |
SketchBinary | 0 |
SMALLINT | 1 |
SMALLINT SIGNED | 1 |
SMALLINT UNSIGNED | 1 |
String | 0 |
TEXT | 1 |
Time | 1 |
TIMESTAMP | 1 |
TINYBLOB | 1 |
TINYINT | 1 |
TINYINT SIGNED | 1 |
TINYINT UNSIGNED | 1 |
TINYTEXT | 1 |
Tuple | 0 |
UInt128 | 0 |
UInt16 | 0 |
UInt256 | 0 |
UInt32 | 0 |
UInt64 | 0 |
UInt8 | 0 |
UUID | 0 |
VARBINARY | 1 |
VARCHAR | 1 |
VARCHAR2 | 1 |