[Vtigercrm-developers] Changing type of data

ardi zeneli zeneliiardi at gmail.com
Wed Jul 15 08:00:47 GMT 2015


Hello Simone,

First i went to the vtiger_field table and found the field i wanted to
change. I changed the uitype from text (1) to text area (19) leaving the
type of data V~O (varchar - Optional).
When this didn't work i tried a different approach. I went to the specific
table vtiger_contactaddress and tried changing the type from VARCHAR to
TEXT. Also i tried changing the character length from 40 to 250 both in
text type and in varchar type. But still no luck.
Hope this helps.

On Wed, Jul 15, 2015 at 9:50 AM, Simone Travaglini <
simonetravaglini at gmail.com> wrote:

> Hi Ardi,
> could you specify exactly what value did you change and in which table?
>
> 2015-07-15 9:43 GMT+02:00 ardi zeneli <zeneliiardi at gmail.com>:
>
>> Hello,
>>
>> I am trying to change the type of an existing text field to a Text Area
>> field. I have alredy tried changing the uitype in the database, changing
>> from varchar to text in the dedicated table in the db or changing the
>> number of characters for this field but still not working.
>> Any hint on how to do this, is there something i am missing?
>>
>> Thanks
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
>
> --
> Simone Travaglini
> 328 5499846
> Linkedin: Simone Travaglini
>
>
> Rispetta l'ambiente: non stampare questa mail se non ti è veramente
> necessario!
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150715/134f4c3e/attachment.html>


More information about the vtigercrm-developers mailing list