Issue Task Closed

#76044Adequate table field declarations in fe_users table

Thomas Löffler 05/04/16, 11:15 updated 10/17/17, 23:32

Description

Hi,

I realized some problems with the length of some fe_users table fields:

  1. There are three fields for name parts (first_name, middle_name, last_name), which have varchar(50). But the field “name” (which would be used to concatenate the other three fields) has varchar(80). Imho this should be increased to varchar(153) minimum (50*3 + 3 spaces).
  2. The fields “phone” and “fax” have varchar(20), which should be increased as well. If you take the international styled phone number from WMDB for example (+49 (0)211 416 889 20), you have 21 chars. And german numbers can be minimum 1 char longer.

Due to the MySQL documentation the varchar field is variable-based and will take that space the content needs, so it should be no problem to increase them:
> Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 65,535. The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used.

Reviews 1

Subtasks 1