dhis2-users team mailing list archive

[Rodolfo Melia <rmelia@xxxxxxxxxxxx>]

Hi - just to echo on Marko's comment: PSI is also considering the use of a
large, free text field, for doctor/ nurse to write free text observations
that we don't need to quantify, but we want to capture, so DHIS can work as
a light electronic health record. We will try Knut's suggestion on the mean
time.


On Fri, Apr 26, 2013 at 8:48 AM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:

> 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
>>
>>
>
> _______________________________________________
> 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
>
>


-- 
*Rodolfo Meliá*
*Principal*
rmelia@xxxxxxxxxxxx
www.knowming.com
+1 708 872 7636
+44 777 576 4090
Skype: rod.melia
Twitter: @RodolfoMelia <https://twitter.com/RodolfoMelia>

Note: Please note my new email address, which I will be using for PSI
related work: rmelia@xxxxxxxxxxxx