If you have "dot zero(s)" values (such as, 4.0) do not save them in an
INTEGER column because then they will lose their float characteristics.
insert into students values(John, 4.0)
select age from students where first_name = 'John'
4 <-- got converted to integer
Regards
/sd
"Mark
Wyszomierski" To:
sqlite-users@sqlite.org
<[EMAIL PROTECTED] cc:
> Subject: [sqlite] specifying
field type, any benefit?
01/04/2006 03:54
PM
Please respond to
sqlite-users
Hi all,
I switched to sqlite from mysql awhile ago, I maintained the field types
in my sqlite implementation such as:
create table students (first_name TEXT, age INTEGER);
I'm just wondering if there is any point to specifying the field type as if
I try adding a string type into the age field, it seems to be accepted ok:
insert into students values('hello');
Does sqlite have any problem regarding setting a field defined as INTEGER
from a text string (any limits etc?), are there any performance gains to be
had with specifying the field type?
Thanks,
Mark
The information transmitted is intended only for the person(s)or entity
to which it is addressed and may contain confidential and/or legally
privileged material. Delivery of this message to any person other than
the intended recipient(s) is not intended in any way to waive privilege
or confidentiality. Any review, retransmission, dissemination or other
use of , or taking of any action in reliance upon, this information by
entities other than the intended recipient is prohibited. If you
receive this in error, please contact the sender and delete the
material from any computer.
For Translation:
http://www.baxter.com/email_disclaimer
