t * from t;
blah
2
2.1
sqlite> select typeof(a) from t;
text
integer
real
Mike
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Wednesday, July 10, 2013 4:10 AM
To: General Discussion of SQLite Database
Sub
On 10 Jul 2013, at 8:44am, Woody Wu wrote:
> I have an old dabase, some integer columns were defined as type of
> number(2).
It limits the number of digits after the decimal point to 2. In other words,
it’s what you might use if you wanted an amount of dollars automatically
truncated to cent
This may help
http://stackoverflow.com/questions/5562322/difference-between-int-and-int3-data-types-in-my-sql
On 10/07/2013, at 6:33 PM, Woody Wu wrote:
> On Wed, Jul 10, 2013 at 10:50:06AM +0200, Paolo Bolzoni wrote:
>> Yes, I think it is possible to put only for
>> compatibility reasons. Mayb
On Wed, Jul 10, 2013 at 10:50:06AM +0200, Paolo Bolzoni wrote:
> Yes, I think it is possible to put only for
> compatibility reasons. Maybe in some
> other db systems you can set the magnitude?
>
Understood. I also don't know why there are number(2) in the schema
that I saw. It's just a database
Yes, I think it is possible to put only for
compatibility reasons. Maybe in some
other db systems you can set the magnitude?
On Wed, Jul 10, 2013 at 10:06 AM, Woody Wu wrote:
> On Wed, Jul 10, 2013 at 09:53:41AM +0200, Paolo Bolzoni wrote:
>> See here:
>> http://www.sqlite.org/datatype3.html
>>
>
On Wed, Jul 10, 2013 at 09:53:41AM +0200, Paolo Bolzoni wrote:
> See here:
> http://www.sqlite.org/datatype3.html
>
> I think it just means Integer. And its
> size depends on the magnitude of the
> number stored.
>
I've read the doc, it's not so easy to understand.
Did you mean, in number(N),
See here:
http://www.sqlite.org/datatype3.html
I think it just means Integer. And its
size depends on the magnitude of the
number stored.
On Wed, Jul 10, 2013 at 9:44 AM, Woody Wu wrote:
> I have an old dabase, some integer columns were defined as type of
> number(2). What does this mean in sq
I have an old dabase, some integer columns were defined as type of
number(2). What does this mean in sqlite3? What's the data ragne it
can represent, and how much bytes it will consume when stored?
Thanks in advance.
--
I can't go back to yesterday - because I was a different person then
_
8 matches
Mail list logo
