In the back end? None. SQLite will accept any value in any field
completely ignoring the typecast you define.
*
SQLite version 3.7.15.1 2012-12-19 20:39:10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table TestTable (SomeInt integer);
sqlite> .table
TestTable
sqlite> insert into TestTable (SomeInt) values ('This is a string');
sqlite> select * from TestTable;
This is a string
sqlite>*
This is perfectly valid in SQLite. The types are there mostly for your
viewing pleasure, and makes it easier to determine if a field name of
'Amount' is supposed to be of a currency/float type, or an integer type. I
say "mostly for your viewing pleasure" because I'm not sure if SQLite
internally pays attention to the type and changes up the indexing mode
depending if results are expected to be numeric or not.
But just because SQLite doesn't pay attention to typecasts, doesn't mean
your application should be ignorant to them. If your application is
expecting only integers, and somehow a string was entered into the field,
you'll either get a run time error, or, zero for a result. (This would
depend on the wrapper for SQLite you're using, or how you're linking in the
library)
On Mon, Jul 15, 2013 at 12:35 AM, techi eth <techi...@gmail.com> wrote:
> I found so many Type name to be used while creating table for array
> type.What is significance of size under bracket ?.What is differences among
> all ?
> http://www.sqlite.org/datatype3.html
> -----------------------
> CHARACTER(20)
> VARCHAR(255)
> VARYING CHARACTER(255)
> NCHAR(55)
> NATIVE CHARACTER(70)
> NVARCHAR(100)
> TEXT
> -----------------------
>
>
> Thanks
>
>
> On Fri, Jul 12, 2013 at 1:07 PM, Hick Gunter <h...@scigames.at> wrote:
>
> > Please read up on SQL, there are numerous tutorials available online.
> >
> > There is no "array" in SQL other than that a table may be considered as
> an
> > array of records.
> >
> > Your example creates a table with two fields named 'test' and 'name' and
> > with declared datatypes of '10' and '50' respectively.
> >
> > -----Ursprüngliche Nachricht-----
> > Von: techi eth [mailto:techi...@gmail.com]
> > Gesendet: Freitag, 12. Juli 2013 09:13
> > An: General Discussion of SQLite Database
> > Betreff: [sqlite] Array Accessing in SQLite3
> >
> > I have query regarding accessing single & multidimensional array in
> > SQLite3.
> >
> > Example: I have created table with (test [10] INTEGER, name [50] TEXT).
> >
> > How do I pass a value to insert each element of array?
> >
> > How do I read back? (I am using callback function for read back)
> >
> >
> > Please cover answer by considering multidimensional array case as well.
> >
> > Thanks--
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
> >
> --------------------------------------------------------------------------
> > Gunter Hick
> > Software Engineer
> > Scientific Games International GmbH
> > Klitschgasse 2 – 4, A - 1130 Vienna, Austria
> > FN 157284 a, HG Wien
> > Tel: +43 1 80100 0
> > E-Mail: h...@scigames.at
> >
> > This e-mail is confidential and may well also be legally privileged. If
> > you have received it in error, you are on notice as to its status and
> > accordingly please notify us immediately by reply e-mail and then delete
> > this message from your system. Please do not copy it or use it for any
> > purposes, or disclose its contents to any person as to do so could be a
> > breach of confidence. Thank you for your cooperation.
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
