Member Avatar for pedramphp

Dear folk,
what should I use for Price Field in Data base
I have used BigInt
But I know I could do it with Decimal , I ned to do it without any Limitation of the size of the digits and the numbers after dot ( . )
so what is the solution ....
thanks

  • 3 Contributors
  • 4 Replies
  • 64 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by pedramphp
Member Avatar for pritaeas

You could use double, but that may give rounding troubles. Instead you could use two bigints. One for the amount without decimal sign, and one to use as divider (1, 10, 100 ...).

Member Avatar for pedramphp

I think I is not Efficient to use two BigInt for a price ....
does Anyone has any Idea?

Member Avatar for Shanti C

use float...

Member Avatar for pedramphp

Foat could support 4byte this means it is limit to 1,000,000,000 number it is limited but Double is 8 byte ....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.