Thanks, Everyone. I think I understand this enough to at least attempt to test it, unfortunately, it will probably be a couple of days before them. I will let you know the results...
Mike On Wed, Jan 28, 2009 at 2:24 AM, MikeW <mw_p...@yahoo.co.uk> 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 >> > > An alternative is to use the sqlite3_column_decltype() > http://www.sqlite.org/c3ref/column_decltype.html > function to read back the string name with which the column > was originally created. > > MikeW > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Peace may sound simple—one beautiful word— but it requires everything we have, every quality, every strength, every dream, every high ideal. —Yehudi Menuhin (1916–1999), musician _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users