diff options
author | unknown <monty@hundin.mysql.fi> | 2002-05-27 23:40:26 +0300 |
---|---|---|
committer | unknown <monty@hundin.mysql.fi> | 2002-05-27 23:40:26 +0300 |
commit | 37db9f71bae8f09a3ca99ce1438aa4131756efd8 (patch) | |
tree | d105f81974b3839debee37e474448c472626fff0 | |
parent | 6ec00a6692b54d5e8e69229404d6da97c0314beb (diff) | |
download | mariadb-git-37db9f71bae8f09a3ca99ce1438aa4131756efd8.tar.gz |
Manual update about SET/ENUM
Docs/manual.texi:
Added information about SET/ENUM
-rw-r--r-- | Docs/manual.texi | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index e34415f437b..a5045dca16b 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -29907,6 +29907,9 @@ have any of the values shown here. The index of each value is also shown: An enumeration can have a maximum of 65535 elements. +Starting from 3.23.51 end space are automaticly deleted from enum values +when the table is created. + Lettercase is irrelevant when you assign values to an @code{ENUM} column. However, values retrieved from the column later have lettercase matching the values that were used to specify the allowable values at table creation time. @@ -29922,7 +29925,9 @@ mysql> SELECT enum_col+0 FROM tbl_name; If you store a number into an @code{ENUM}, the number is treated as an index, and the value stored is the enumeration member with that index. (However, this will not work with @code{LOAD DATA}, which treats all -input as strings.) +input as strings.). Becasue of this, it's not advisable to store +numbers in an enum string (You will be confused sooner or later if you +do this). @code{ENUM} values are sorted according to the order in which the enumeration members were listed in the column specification. (In other words, @@ -29961,6 +29966,9 @@ any of these values: A @code{SET} can have a maximum of 64 different members. +Starting from 3.23.51 end space are automaticly deleted from @code{SET} +values when the table is created. + MySQL stores @code{SET} values numerically, with the low-order bit of the stored value corresponding to the first set member. If you retrieve a @code{SET} value in a numeric context, the value retrieved has bits set |