On 3/4/08, Gilles Ganault <[EMAIL PROTECTED]> wrote: > On Tue, 4 Mar 2008 11:03:44 -0600, "P Kishor" > <[EMAIL PROTECTED]> wrote: > >I think that was the point of my saying, "Anything using SQLite is > >free to do what it wants." I routinely write Perl code that checks > >what I am inserting into SQLite and croaks if something is not as I > >expected. > > So, even though SQLite only differentiates between numeric and text, > connectors for such and such language might be more rigid, and have an > issue with TEXT.
I think you really need to read <http://www.sqlite.org/datatype3.html> SQLite doesn't differentiate anything, although you can make it do so with CHECK CONSTRAINTS or with your own code. If you insist on shoving numbers in text or text in numbers or music or photos or molecular structures in varchar, SQLite will happily comply. The following, for example, is a valid SQLite schema [02:45 PM] ~$ sqlite3 foo.db SQLite version 3.5.6 Enter ".help" for instructions sqlite> CREATE TABLE magic (a ELEPHANT, b TIGER, c AIRPLANE); sqlite> INSERT INTO magic (a, b, c) VALUES ('punkish', 234, '*&*^%^&'); sqlite> SELECT * FROM magic; punkish|234|*&*^%^& sqlite> .s CREATE TABLE magic (a ELEPHANT, b TIGER, c AIRPLANE); sqlite> In some ways, Richard has spoiled me. After using SQLite, every other db is a chore. It gives me complete control to do what I want to, and does exceedingly well what it claims to... return my data to me incredibly fast when I query it. My logic is in my application. > > I only know of two connectors for SQLite3 in active development: > Aducom, and DISQLite. I haven't successfully used the latter yet, so > don't know if it also has the MEMO issue with TEXT. > I don't know what you mean by "active development" as DBD::SQLite is under very active development, in the sense that it gets updated occasionally. Same is likely true for Python or PHP "connectors." Although others using the same connectors on this list might be able to assist, you would likely get more directed help on deeper "connector" issues on those connector mailing lists, if they have any. Puneet. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
