2 Replies Latest reply: Aug 23, 2010 3:45 PM by Guest RSS

Data type to store longest positive number

Kumud Singh
Currently Being Moderated

Hi Experts,

 

Requirement is:  A number, lets say count, gets updated based on a certain criteria.

 

count = count + 1.

 

This happens at regular intervals.

 

I have to store this updated value in a table.

What should be the datatype for this field.

There is no restriction on the count. It can be ever increasing.

 

 

Kindly acknowledge.

 

With Regards,

 

Kumud

  • Re: Data type to store longest positive number
    Raymond Giuseppi
    Currently Being Moderated

    There is no datatype able to contain an infinite integer so there is strictly no absolute answer to your question.

    ...

    Nevertheless you could use a NUMC field, which length can reach 255 characters. (a century lasts only 3.155.760.000 s, so even if your counter is incremented every ms, you have the time to leave...

     

    INT4 could be a little two short (max 2.147.483.647, but you could start at -2.147.483.647)

     

    Regards,

    Raymond

  • Re: Data type to store longest positive number
    Currently Being Moderated

    Hi,

     

    try this way..

     

    Create Domain with data type 'NUMC' and Number of Charatcers as '50'.

     

    then There is no restriction on the count. It can be ever increasing upto to 100 lenght.

     

    Prabhudas

Actions