summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorunknown <monty@hundin.mysql.fi>2002-05-27 23:40:26 +0300
committerunknown <monty@hundin.mysql.fi>2002-05-27 23:40:26 +0300
commit37db9f71bae8f09a3ca99ce1438aa4131756efd8 (patch)
treed105f81974b3839debee37e474448c472626fff0
parent6ec00a6692b54d5e8e69229404d6da97c0314beb (diff)
downloadmariadb-git-37db9f71bae8f09a3ca99ce1438aa4131756efd8.tar.gz
Manual update about SET/ENUM
Docs/manual.texi: Added information about SET/ENUM
-rw-r--r--Docs/manual.texi10
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