Hi,
I am working with sqlite 3.3.6 version.
I have defined the macro SQLITE_OMIT_FLOATING_POINT.
1.
this is my test program
"create table Test(id integer primary key,player char);"
"insert into Test(id,player) values(2,'surya');"
"insert into Test(id,player) values(9223372036854775807,'sree');"
"insert into Test(player) values('sree1');"
A random number is choosen for the player sree1.
What i need is i want to fix the maximum limit to say 64k.
So that it will be easy for me for maintaining the records. is there any
possibility of setting the maximum limit.
I tried changing the value of SQLITE_BIG_DBL it did not worked.
2.
My second doubt.
"create table Test(id integer primary key,player char);"
"insert into Test(id,player) values(2,'surya');"
"insert into Test(id,player) values(9223372036854775807,'sree');"
"insert into Test(id,player) values(9223372036854775808,'sree1');"
"select * from Test;"
The result is
-9223372036854775808 sree1
2 surya
9223372036854775807 sree
I tried inserting 2 power 63 value but the database has converted it to -2
power 63 and stored.
Can anyone explain why this has happened.
Best Regards,
A.Sreedhar.
Jasmin Infotech Pvt. Ltd.
Plot 119, Velachery Tambaram Road,
(Opposite NIOT), Pallikaranai,
Chennai 601 302
India
Tel: +91 44 3061 9600 ext 3057
Fax: + 91 44 3061 9605
***************************************************************************
Information in this email is proprietary and Confidential to
Jasmin Infotech. Any use, copying or dissemination of the
information in any manner is strictly prohibited. If you are
not the intended recipient, please destroy the message and please inform us.
****************************************************************************
