Nope. The reason to define datatype in SQLite is because other databases do so. The difference ist hat SQLite does not enforce typing but uses the concept of affinity instead.
-----Urspr?ngliche Nachricht----- Von: Nicolas J?ger [mailto:jagernicolas at legtux.org] Gesendet: Donnerstag, 27. August 2015 16:07 An: sqlite-users at mailinglists.sqlite.org Betreff: Re: [sqlite] why I don't get an error ? Hi Darko, Igor and others. so the only reason to define datatype in sqlite is for the size on the disk ? so why not just only using `BLOB` (excepted for `INTEGER PRIMARY KEY`) ? being less persmissive wouldn't make querries run faster ? for example, the comparisons would not have to try to attempt to convert or even check and determine the type of the values. regards, Nicolas J. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: hick at scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation.