dhis2-devs team mailing list archive

[Saptarshi Purkayastha <sunbiz@xxxxxxxxx>]

Hi,

If you check the systemsetting table... the datatype for the value column is
BLOB <http://en.wikipedia.org/wiki/Binary_large_object>
A MySQL explanation is here:
http://dev.mysql.com/doc/refman/5.0/en/blob.html

Using string key, string value seems like the standard way to store
properties. Wanted to know if its been well thought-out to use BLOB here

---
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


On 31 March 2010 19:56, Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx> wrote:

> Dear Saptarshi,
>
> Do you mind if you can explain to me about BLOB value? What's BLOB here?
>
> Really thanks !
>
> On Wed, Mar 31, 2010 at 8:29 PM, Saptarshi Purkayastha <sunbiz@xxxxxxxxx>wrote:
>
>> I was looking at the systemsettings... and found that the value is stored
>> as a BLOB. I was greatly surprised to see this... Any good reason to do
>> this??
>>
>> ---
>> Regards,
>> Saptarshi PURKAYASTHA
>> Director R & D, HISP India
>> Health Information Systems Programme
>>
>> My Tech Blog:  http://sunnytalkstech.blogspot.com
>> You Live by CHOICE, Not by CHANCE
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Hieu.HISPVietnam
> Good Health !
>