mysql>
mysql> CREATE TABLE textblob_val
-> (
-> tstr TEXT, # not case sensitive
-> bstr BLOB # case sensitive
-> );
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql>
mysql> INSERT INTO textblob_val (tstr,bstr) VALUES('aaa','aaa'),
-> ('AAA','AAA'),
-> ('bbb','bbb'),
-> ('BBB','BBB');
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql>
mysql> SELECT * FROM textblob_val;
+------+------+
| tstr | bstr |
+------+------+
| aaa | aaa |
| AAA | AAA |
| bbb | bbb |
| BBB | BBB |
+------+------+
4 rows in set (0.00 sec)
mysql>
mysql> SELECT MIN(LOWER(bstr)) FROM textblob_val;
+------------------+
| MIN(LOWER(bstr)) |
+------------------+
| AAA |
+------------------+
1 row in set (0.00 sec)
mysql>
mysql> drop table textblob_val;
Query OK, 0 rows affected (0.00 sec)