在SQLite3中存储货币值
我正在处理应用程序中的许多不同货币，我想知道将它们存储在SQLite3数据库中的最佳方法是什么。
I'm dealing with lots of different currencies in my application, and I want to know what the "best" way is to store them in an SQLite3 database.
我倾向于定点表示（即，将它们存储为整数，其中$ 3.59被存储为359，¥400被存储为40000）。这是一个好主意吗？
I'm leaning towards a fixed-point representation (i.e. store them as integers, where $3.59 gets stored as 359, ¥400 stored as 40000). Is this a good idea? What if my input data later changes and requires more precision?
鉴于SQLite 3将最多使用8个字节来存储 INTEGER 类型，除非您要使用大于10 ^ 16的数字，否则就可以了。
Given that SQLite 3 will use up to 8 bytes to store INTEGER types, unless you are going to have numbers greater than 10^16, you should be just fine.
从角度看，以千分之一美元（工厂）表示的世界国内生产总值约为61'000'000'000'000'000 sqlite3表示没有问题。
To put this in perspective, the world gross domestic product expressed in thousandths of a USD (a mill) is about 61'000'000'000'000'000 which sqlite3 has no problem expressing.
sqlite> create table gdp (planet string, mills integer);
sqlite> insert into gdp (planet, mills) values ('earth', 61000000000000000000);
sqlite> select * from gdp;
earth|61000000000000000000
除非您正在处理行星际会计，否则我认为您没有担心。
Unless you are handling interplanetary accounting, I don't think you have to worry.