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