Which data type should I select?

  • Thread starter Thread starter Niklas Östergren
  • Start date Start date
N

Niklas Östergren

Hi!

I have started with a db storing a control system parameters. The control
system have 6 different types of datatypes for their parameters, as follows:

BitType (00000010)
ByteType (-128 to 127)
AxisByteType (0 to 255)
WordType (-32 768 to 32 767)
AxisWordType (0 to 65 355)
2WordType (-99 999 999 to 99 999 999)

I just need help with you telling me if the datatype that I would like to
use is the best one with small memory allocation in mind! I would like to
use following datatypes:

BitType (Long)
ByteType (Integer)
AxisByteType (Byte)
WordType (Integer)
AxisWordType (Long)
2WordType (Long)

I´m not sure about using Long for BitType or if there might be a better
datatype to use. The only data going to be stored here is 1 byte (8 bits, 0
and 1).

TIA!
// Niklas
 
OK!

I thought that I might needed to use text for this one, unfortunately, since
it recuires more memory. But now when you mention it I remeber and I don´t
have any other option so text it has to be!

Thanks!
// Niklas
 
Back
Top