root@192.168.5.244 [ediscovery] 01:09:20> SELECT LENGTH('catherine.huynh@enron.com '),CHAR_LENGTH('catherine.huynh@enron.com '),LENGTH('catherine.huynh@enron.com'),CHAR_LENGTH('catherine.huynh@enron.com');
+--------------------------------------+-------------------------------------------+-------------------------------------+------------------------------------------+
| LENGTH('catherine.huynh@enron.com ') | CHAR_LENGTH('catherine.huynh@enron.com ') | LENGTH('catherine.huynh@enron.com') | CHAR_LENGTH('catherine.huynh@enron.com') |
+--------------------------------------+-------------------------------------------+-------------------------------------+------------------------------------------+
|                                   26 |                                        26 |                                  25 |                                       25 |
+--------------------------------------+-------------------------------------------+-------------------------------------+------------------------------------------+
1 row in set (0.00 sec)

root@192.168.5.244 [ediscovery] 01:11:32> CREATE TABLE whitespace_test (a char(30), b varchar(255), c text );
Query OK, 0 rows affected (0.02 sec)

root@192.168.5.244 [ediscovery] 01:12:07> INSERT INTO whitespace_test (a,b,c) VALUES ('catherine.huynh@enron.com ','catherine.huynh@enron.com ','catherine.huynh@enron.com ');
Query OK, 1 row affected (0.00 sec)

root@192.168.5.244 [ediscovery] 01:12:31> SELECT LENGTH(a),LENGTH(b),LENGTH(c) FROM whitespace_test;
+-----------+-----------+-----------+
| LENGTH(a) | LENGTH(b) | LENGTH(c) |
+-----------+-----------+-----------+
|        25 |        26 |        26 |
+-----------+-----------+-----------+
1 row in set (0.00 sec)

root@192.168.5.244 [ediscovery] 01:12:45> SELECT CHAR_LENGTH(a),CHAR_LENGTH(b),CHAR_LENGTH(c) FROM whitespace_test;
+----------------+----------------+----------------+
| CHAR_LENGTH(a) | CHAR_LENGTH(b) | CHAR_LENGTH(c) |
+----------------+----------------+----------------+
|             25 |             26 |             26 |
+----------------+----------------+----------------+
1 row in set (0.00 sec)

root@192.168.5.244 [ediscovery] 01:13:02> SELECT BIT_LENGTH(a),BIT_LENGTH(b),BIT_LENGTH(c) FROM whitespace_test;
+---------------+---------------+---------------+
| BIT_LENGTH(a) | BIT_LENGTH(b) | BIT_LENGTH(c) |
+---------------+---------------+---------------+
|           200 |           208 |           208 |
+---------------+---------------+---------------+