Bug #14290 wrong CHARACTER_MAXIMUM_LENGTH value for some text fields

• Submitted: 25 Oct 2005 11:27
• Modified: 31 Oct 2005 20:00
• Reporter: Ramil Kalimullin
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Assigned to: Ramil Kalimullin
• CPU Architecture: Any

[25 Oct 2005 11:27] Ramil Kalimullin

Description:
CHARACTER_MAXIMUM_LENGTH value has to be adjusted for multibyte text 
fields.

How to repeat:
mysql> create table t1(a blob, b text charset utf8, c text charset ucs2);
Query OK, 0 rows affected (0.01 sec)

mysql> select column_name, data_type, character_octet_length, character_maximum_length from information_schema.columns where table_name='t1';
+-------------+-----------+------------------------+--------------------------+
| column_name | data_type | character_octet_length | character_maximum_length |
+-------------+-----------+------------------------+--------------------------+
| a           | blob      |                  65535 |                    65535 |
| b           | text      |                  65535 |                    65535 |
| c           | text      |                  65535 |                    65535 |
+-------------+-----------+------------------------+--------------------------+
3 rows in set (0.06 sec)

[25 Oct 2005 12:25] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/31450

[27 Oct 2005 14:42] Ramil Kalimullin

fixed in 5.0.16

[31 Oct 2005 20:00] Paul DuBois

Noted in 5.0.16 changelog.