In one of our Sqlite applications the gratuitous type changes of Sqlite were incompatible and it took only a very few patches to the Sqlite source to disable the detection and change code.
Clay Dowling wrote: > Simon de Hartog wrote: > >>SQLite has a feature called Manifest typing. As with many features of >>software I run, I wonder whether this feature can be disabled. I prefer >>to use static typing in my databases to prevent stored values not being >>what my code (C++) expects them to be. So in short: is it possible to >>use static typing instead of manifest typing in SQLite? > > If you access the database strictly through your software, this is > trivially easy if you are using a strongly typed language like Pascal or > C. Simply force the data to be of the appropriate type in your program > and it will be stored as the appropriate type in your database. > > If you are allowing direct access to the database via SQL, you can > probably assume that any user smart enough to write their own > insert/update queries can probably also work out the correct data > types. If not, you may wish to reconsider allowing direct SQL access. > > Clay > _______________________________________________ > 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