dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Marko,

we could consider it - the only problem is that we have chosen the approach
of using one column for all types of values. Most values are short numbers
and using text as column type over varchar with fixed length implies a
performance penalty. I am not sure how significant that overhead is with
latest versions of postgresql/mysql. We could check it out. I guess you
could do like Knut suggests for now and change the column type manually.

cheers

Lars



On Fri, Apr 26, 2013 at 5:29 AM, Marko David Garcia
<markodavidgm@xxxxxxxxx>wrote:

> Hi friends, in the table patientdatavalue the field value is varchar(255).
>
> Is possible change this field to a bigger type?
>
> We need insert long descriptions in this field.
>
> Thank you very much.
>
> --
> Cordialmente,
>
>
> *Ing. Marko David Garcia M.
> *
> *Área de Sistemas integrados de Información
> Secretaría de Salud Departamental del Cauca
>
> *
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>