We do thisby usig the Sqlite "Declared Type" (which can be anything you choose) and intercepting it in a layer of software between Sqlite and the application language manager. For example we have a decimal number type, a date type etc. The data is stored as Sqlite TEXT or FLOAT but the interface handle transformatiuon into the decimal or date format exopecrted by the host langauge processor.
MikeW wrote: > Mike McGonagle <mjm...@...> writes: > > >> Hello all, >> >> I am in the process of integrating SQLite into a multimedia >> environment/programming language. One thing that I would like to be >> able to do is support all the various datatypes in this language, and >> one in particular is a list of other primitive datatypes. Is there a >> way to add a "user-type" so that when 'sqlite3_column_type' is called, >> it would return a unique ID for this "user-type"? >> >> I am hoping that I can use this to do some further processing to the >> stored data to convert it back into the native format the environment >> uses. >> >> Or is there a better way? >> >> Thanks, >> >> Mike >> >> > > Another separate field for the data type ? > > MikeW > > == gmane padding === > == gmane padding === > == gmane padding === > == gmane padding === > == gmane padding === > > > > _______________________________________________ > 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