Re: set column type - case sensitive
Here's what I get with exactly the same code:
[tt]
mysql> CREATE TABLE t
-> (
-> mycharcol CHAR(1),
-> mysetcol SET("a","A","b","B","c","C") BINARY
-> );
Query OK, 0 rows affected, 3 warnings (0.03 sec)
mysql> INSERT INTO t (mycharcol,mysetcol)
-> VALUES ("a","a"),("b","b"),("c","c"),("A","A"),("B","B"),("C","C");
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql> SELECT *
-> FROM t;
+-----------+----------+
| mycharcol | mysetcol |
+-----------+----------+
| a | a |
| b | b |
| c | c |
| A | a |
| B | b |
| C | c |
+-----------+----------+
6 rows in set (0.00 sec)
mysql> select * from t where mysetcol in ('a','b','c');
+-----------+----------+
| mycharcol | mysetcol |
+-----------+----------+
| a | a |
| b | b |
| c | c |
| A | a |
| B | b |
| C | c |
+-----------+----------+
6 rows in set (0.00 sec)
mysql> select * from t where mysetcol in ('A','B','C');
Empty set (0.00 sec)
mysql> show variables like 'version';
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| version | 4.1.7-nt |
+---------------+----------+
1 row in set (0.00 sec)
[/tt]