Hi We are having problems capturing, storing, exporting and importing data comprising large numbers - with an annual public health budget of around R 150 billion, SA has a considerable number of financial data values well above 2 billion. While we CAN find ways of inserting such values since the value field in the DataValue table is char var, they don't process well and don't export/import well (e.g. the large values are exported into CSV as exponential number strings, which in turn is rejected during import into another instance).
Most database including PostgreSQL supports a BIGINT data type (8 bytes), which would work for us. DHIS2 don't support BIGINT as a data type via the UI, but: 1. Anybody know of a way to circumvent that? 2. What the code implications of adding another data type - does it require code changes all over the place, or is the code reasonably contained? Regards Calle ******************************************* Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRIC Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: [email protected] Skype: calle_hedberg *******************************************
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
