On 27/03/2011, at 3:04 PM, Patrick Earl wrote:
If you use a view to return a double, you've lost the exact value you were
trying to save by storing the decimal as a text value.
I'm not suggesting storing as a text value. I'm suggesting storing as an
integer and only converting to a float
On Mar 26, 2011, at 10:15 PM, BareFeetWare wrote:
On 27/03/2011, at 12:39 PM, Patrick Earl wrote:
Base-10 numbers are frequently used in financial calculations because
of their exact nature. SQLite forces us to store decimal numbers as
text to ensure precision is not lost. Unfortunately,
For those who are scared by this, there really isn't that much to do. Let us,
for the same of argument, say we're going to allow decimal values to an
arbitrary length: any number of digits, possibly with a decimal point somewhere
along the string, possibly starting with a minus sign.
The
Base 10 multiplication is needed. Although money is the main reason for doing
BCD due to cumulative errors it's not the only reason. So I'd recommend adding
decimal*decimal - decimal just to be complete. It's easy enough to implement
using the + function so could just be noted as slow.
All --
This page has a lot of info about
Decimal Number support, including
a set of libraries:
http://speleotrove.com/decimal/
-- kjh
Black, Michael (IS) wrote, On 03/27/2011 06:29 AM:
Base 10 multiplication is needed. Although money is the main reason for
doing BCD due to cumulative
There are many cases where people are doing calculations or using
numbers expecting them to retain all digits. This would allow the BCD
type to be used for that if they really need it.
Currency conversions (rarely exact!) or tax (or margin) calculations
come to mind as very common uses
This page has a lot of info about
Decimal Number support, including
a set of libraries:
http://speleotrove.com/decimal/
Yes! IBM and Intel are two of the big names having done significant
work in this direction and made research and/or results publicly available.
On 27 Mar 2011, at 11:49am, Simon Slavin wrote:
decimal + decimal -- decimal
decimal - decimal -- decimal
decimal * real -- decimal
decimal / real -- decimal
decimal / decimal -- real
I forgot a bunch of functions. You need to be able to do comparisons, so you
can determine whether one
From: Patrick Earl pate...@patearl.net
Subject: Re: [sqlite] Lack of decimal support
If SQLite can't decide on a base-10 format itself, perhaps the answer
lies in enhancing the API to allow for custom type storage and
operators.
So, like a virtual type interface. This would be a nice feature.
Simon Slavin wrote:
I forgot a bunch of functions. You need to be able to do comparisons, so you
can determine whether one decimal is greater, less or equal to another. And
users will want abs(), max(), min(), round(), avg(), sum(), and total().
What is this total function you speak of and
On 27 Mar 2011, at 7:17pm, Darren Duncan wrote:
Simon Slavin wrote:
I forgot a bunch of functions. You need to be able to do comparisons, so you
can determine whether one decimal is greater, less or equal to another. And
users will want abs(), max(), min(), round(), avg(), sum(), and
Is my impression correct that when calling sqlite3_step() on a query
that returns no rows, the result will be [SQLITE_DONE]? If that is
the case, might that be added to the documentation?
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 27 Mar 2011, at 9:24pm, Sam Carleton wrote:
Is my impression correct that when calling sqlite3_step() on a query
that returns no rows, the result will be [SQLITE_DONE]? If that is
the case, might that be added to the documentation?
The SQLite documentation would profit greatly from a
I have python 2.6 on my ubuntu 10.04 workstation.
the sqlite module imports without a problem.
I have installed python 2.7 by compiling it.
There is no /usr/local/lib/python2.7/lib-dynload/_sqlite3.so,
so am getting an import error.
What do I need to do?
FYI: Programmer 24 years, linux 11 years,
Sam Carleton scarle...@miltonstreet.com wrote:
Is my impression correct that when calling sqlite3_step() on a query
that returns no rows, the result will be [SQLITE_DONE]?
Yes.
If that is the case, might that be added to the documentation?
SQLITE_DONE means that the statement has finished
Hi,
I am new to SQLite and am using it for the first time. I need to create an
application using C# that will export the data from EXCEL to SQLite. Please
can anybody guide me.
Thanks in advance!
--
View this message in context:
* Tim Johnson t...@johnsons-web.com [110327 16:59]:
I have python 2.6 on my ubuntu 10.04 workstation.
the sqlite module imports without a problem.
I have installed python 2.7 by compiling it.
There is no /usr/local/lib/python2.7/lib-dynload/_sqlite3.so,
so am getting an import error.
What
On Sun, Mar 27, 2011 at 11:33 AM, jeff archer jarch...@yahoo.com wrote:
From: Patrick Earl pate...@patearl.net
Subject: Re: [sqlite] Lack of decimal support
If SQLite can't decide on a base-10 format itself, perhaps the answer
lies in enhancing the API to allow for custom type storage and
On Sat, Mar 26, 2011 at 8:56 PM, Patrick Earl pate...@patearl.net wrote:
1. Support for a base-10 numeric data type.
Looking at the wikipedia page for NHibernate it seems that you don't
export a SQL interface -- all SQL is generated. So, given that, you
should be able to generate SQLite3
Hi,
Try use www.libxl.com that has C/C++/C#/Delphi interface to read excel files.
The rest are just normal sqlite commands.
On 28-Mar-2011, at 9:17 AM, Deepti Marathe wrote:
Hi,
I am new to SQLite and am using it for the first time. I need to create an
application using C# that will
Nico Williams wrote:
User defined types. There are two types in particular that I'd like
to see added:
- Bit strings. Bit strings are like character strings, but the
elements can only be bits. The key is that bit string length matters
when it comes to collation (000 sorts before ).
Hi ,
If its possible to use Collator of ICU collation service which is base on
both simultaneously :
1. Locale base like ko_KR ( coll = ucol_open(ko_KR, status) )
2. Customized Rules ie tailoring ( coll = ucol_openRules(rlz, rlen,
UCOL_OFF,UCOL_TERTIARY,NULL,status) )
Collator_Final =
On Sun, Mar 27, 2011 at 10:20 PM, Darren Duncan dar...@darrenduncan.net wrote:
Nico Williams wrote:
User defined types. There are two types in particular that I'd like
to see added:
- Bit strings. Bit strings are like character strings, but the
elements can only be bits. The key is that
23 matches
Mail list logo