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 <[email protected]>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 < > [email protected]> 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 : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- *Rodolfo Meliá* *Principal* [email protected] 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: [email protected]
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
