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