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"
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"
- 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
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
..@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
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
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
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
8 matches
Mail list logo