SV: [turba] addressbook / email field limitation..

[Stephane Morand]

Do you know if any changes have been done yet ?

-Steph



On Tue, 9 Apr 2002, Niklas Ogren wrote:

> 255 is the maximum for varchar. It is possible just to change the type to
> text. Some layout issuses has to be considered by the turba team though..
> 
> /Niklas
> 
> -----Ursprungligt meddelande-----
> Fran: Stephane Morand [mailto:Stephane.Morand@polytechnique.fr]
> Skickat: den 9 april 2002 15:25
> Till: turba@lists.horde.org
> Amne: [turba] addressbook / email field limitation..
> 
> 
> 
> Hi,
> 
> Lot of my users use their addressbook. Some of them have "lists". This
> means they include 10, 15 or 20 email address in the email field in "add
> contact"
> 
> But this field is limited, i beleive to 255 caracteres (I use mysql):
> 
> 
> 
> mysql> desc turba_objects;
> +--------------------+--------------+------+-----+---------+-------+
> | Field              | Type         | Null | Key | Default | Extra |
> +--------------------+--------------+------+-----+---------+-------+
> | object_id          | varchar(32)  |      | PRI |         |       |
> | owner_id           | varchar(255) |      |     |         |       |
> | object_name        | varchar(255) | YES  |     | NULL    |       |
> | object_alias       | varchar(32)  | YES  |     | NULL    |       |
> | object_email       | varchar(255) | YES  |     | NULL    |       |
> | object_homeAddress | varchar(255) | YES  |     | NULL    |       |
> | object_workAddress | varchar(255) | YES  |     | NULL    |       |
> | object_homePhone   | varchar(25)  | YES  |     | NULL    |       |
> | object_workPhone   | varchar(25)  | YES  |     | NULL    |       |
> | object_cellPhone   | varchar(25)  | YES  |     | NULL    |       |
> | object_fax         | varchar(25)  | YES  |     | NULL    |       |
> | object_title       | varchar(32)  | YES  |     | NULL    |       |
> | object_company     | varchar(32)  | YES  |     | NULL    |       |
> | object_notes       | text         | YES  |     | NULL    |       |
> +--------------------+--------------+------+-----+---------+-------+
> 14 rows in set (0.00 sec)
> 
> 
> 
> Plus some of them can't see all the address in one time (the window is too
> small).
> 
> Does anyone have any tips about expending these limitations? Is there any
> update ? (I use Turba
> 1.1 (RC1))
> 
> Any help would be apreciated a lot, so my users will stop to bore me!
> 
> 
> -Stephan
> 
> 
> --
> Turba mailing list: http://horde.org/turba/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: turba-unsubscribe@lists.horde.org
> 
> 
> 

-- 
------------------------------------------
Stephane Morand
Laboratoire PMC - Ecole Polytechnique
91128 Palaiseau cedex, France
Stephane.Morand@polytechnique.fr
Tel  +33 1 6933 4431   Fax +33 1 6933 3004
------------------------------------------