diff options
| author | Joe7 <jozsef.rnagy@site.hu> | 2011-01-03 15:44:36 +0100 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2011-01-03 11:08:21 -0800 |
| commit | b26eff7f23b970a7983baf5e211ba88968effb9d (patch) | |
| tree | b877468ab543003058e00db9867c3921904ebe83 /installer | |
| parent | 7ce902d373ac67d2267a886c18238eb53dd98093 (diff) | |
Bugfix: input validation validates description up to length of 65535 chars, but DB trimmed data over 2048 chars. Converting column into TEXT type.
Note: The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used.
In contrast to CHAR, VARCHAR values are stored as a one-byte or two-byte length prefix plus data. The length prefix indicates the number of bytes in the value. A column uses one length byte if values require no more than 255 bytes, two length bytes if values may require more than 255 bytes.
Diffstat (limited to 'installer')
| -rw-r--r-- | installer/install.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/installer/install.sql b/installer/install.sql index 2a2bf269..7a0f99c4 100644 --- a/installer/install.sql +++ b/installer/install.sql @@ -152,7 +152,7 @@ CREATE TABLE {items} ( `album_cover_item_id` int(9) DEFAULT NULL, `captured` int(9) DEFAULT NULL, `created` int(9) DEFAULT NULL, - `description` varchar(2048) DEFAULT NULL, + `description` TEXT DEFAULT NULL, `height` int(9) DEFAULT NULL, `left_ptr` int(9) NOT NULL, `level` int(9) NOT NULL, |