On 5/19/08, Skip Evans <[EMAIL PROTECTED]> wrote: > What happens if the field in the table is defined > as int(11) but the insert command wraps the values > with single quotes?
What do you mean by "insert command wraps the values with single quotes"? You can't wrap values with single quotes in an integer, as far as I know. > > In MySQL this makes no difference. All the > operations still work the same. > > Is SQLite different? Here are a few suggestions for the long haul -- 1. Start here http://www.sqlite.org/datatype3.html 2. Read the rest of the documentation 3. Don't compare SQLite with xyz database. SQLite has its own strengths and weaknesses. Exploit its strengths. > > Thanks! > > Skip > > > -- > Skip Evans > Big Sky Penguin, LLC > 503 S Baldwin St, #1 > Madison, WI 53703 > 608-250-2720 > http://bigskypenguin.com > =-=-=-=-=-=-=-=-=-= > Check out PHPenguin, a lightweight and versatile > PHP/MySQL, AJAX & DHTML development framework. > > http://phpenguin.bigskypenguin.com/ > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
