What data type can I use to store a number larger than 5 billion?
I issue this (against an integer column)
update company_profiles set year_end_shares = '10862000000' where stock_symbol = 'MSFT';
and get back
-2022901888
Is there no native datatype to store anything larger than 5 billion? Sorting a varchar with numbers in them is a bad way to go, I think.
Thanks,
Matt Pressnall
The Seattle Times
I issue this (against an integer column)
update company_profiles set year_end_shares = '10862000000' where stock_symbol = 'MSFT';
and get back
-2022901888
Is there no native datatype to store anything larger than 5 billion? Sorting a varchar with numbers in them is a bad way to go, I think.
Thanks,
Matt Pressnall
The Seattle Times