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
pedramphp
0
Newbie Poster
Recommended Answers
Jump to PostYou 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 ...).
All 4 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
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 ...).
pedramphp
0
Newbie Poster
I think I is not Efficient to use two BigInt for a price ....
does Anyone has any Idea?
Shanti C
106
Posting Virtuoso
use float...
pedramphp
0
Newbie Poster
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.