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

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 ...).

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

use float...

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.