Re: [sqlite] low-level view of data values?

2009-10-13 Thread Dan Phillips
On Tue, Oct 13, 2009 at 11:07 PM, Fred Williams wrote: > The best way I have found to manage decimal (Business math) with most all > the databases is to use integers and multiply and divide by the decimal > offset (i.e. 10, 100, 1000) for presentation purposes,  doing my own > "bankers rounding"

Re: [sqlite] low-level view of data values?

2009-10-13 Thread Simon Slavin
On 13 Oct 2009, at 2:07pm, Fred Williams wrote: > The best way I have found to manage decimal (Business math) with > most all > the databases is to use integers and multiply and divide by the > decimal > offset (i.e. 10, 100, 1000) for presentation purposes, doing my own > "bankers rounding"

Re: [sqlite] low-level view of data values?

2009-10-13 Thread Fred Williams
- Original Message - From: "Dan Phillips" To: "General Discussion of SQLite Database" Sent: Tuesday, October 13, 2009 2:40 AM Subject: Re: [sqlite] low-level view of data values? > On Tue, Oct 13, 2009 at 2:01 AM, Robert Simpson > wrote: >> I'm p

Re: [sqlite] low-level view of data values?

2009-10-13 Thread Dan Phillips
On Tue, Oct 13, 2009 at 2:01 AM, Robert Simpson wrote: > I'm pretty sure I do store them as strings -- SQLite doesn't have a > "decimal" datatype, and "double" doesn't cut the precision mustard for > emulating "decimal". Yes, but I believe the Decimals-as-text will only work if the column is decl

Re: [sqlite] low-level view of data values?

2009-10-12 Thread Robert Simpson
..@sqlite.org] On Behalf Of Dan Phillips Sent: Monday, October 12, 2009 3:38 AM To: sqlite-users@sqlite.org Subject: [sqlite] low-level view of data values? Is it possible in any way to get a low level view of the values in my database in order to see exactly what types they are stored as? The reas

Re: [sqlite] low-level view of data values?

2009-10-12 Thread Dan Phillips
On Mon, Oct 12, 2009 at 9:38 PM, Igor Tandetnik wrote: > Dan Phillips wrote: >> Is it possible in any way to get a low level view of the values in my >> database in order to see exactly what types they are stored as? > > typeof Thanks. It seems you have to declare the column as TEXT for Decimals

Re: [sqlite] low-level view of data values?

2009-10-12 Thread Igor Tandetnik
Dan Phillips wrote: > Is it possible in any way to get a low level view of the values in my > database in order to see exactly what types they are stored as? typeof http://www.sqlite.org/lang_corefunc.html Igor Tandetnik ___ sqlite-users mailing list

[sqlite] low-level view of data values?

2009-10-12 Thread Dan Phillips
Is it possible in any way to get a low level view of the values in my database in order to see exactly what types they are stored as? The reason I ask is that I am using SQLite.NET, and I believe that it stores the .Net Decimal type (this is a decimal floating point type) as strings. I would like