On 19 Dec 2011, at 7:18pm, Alexandre K wrote: > @Simon : Do you mean to store as integer or string whereas the Numeric > (x,y) column type exists, in order to have a nice binding in C ?
The numeric (x,y) column type does not exist. SQLite supports only the following five types: <http://www.sqlite.org/datatype3.html> Any attempt to specify an (x,y) is ignored as you can see by the 'DECIMAL(10,5)' example in section 2.2. I meant to multiply your numbers by a power of ten (in the case of Euros, you would need to multiply by 100) then use the integer binding function to bind them to an INTEGER column. So what you are actually storing is the number of cents, not the number of euros. I have a GPS application which stored GPS coordinates to 5 digits. For instance, -54.27462. It stores its values in a SQLite database as integers, so that particular value is stored as -5427462. This allows me to do various mathematics functions on them like min(lat) and max(lat), and to find stored values in certain ranges. Though I have to remember to multiply my comparison values by 100000. > It's sure that I want to have sum() and others operations on the column and > the 'good' type if possible. I guess it is impossible to bind with string > type with a numeric column, maybe with bytes and void pointer > (sqlite3_bind_blob or other) ? You could bind them as BLOBs. That solution hadn't occurred to me. But then you would not be able to perform any maths on them so doing sum(price) would not work. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
