D. Richard Hipp skrev: > Perhaps: SELECT CAST(b AS TEXT) FROM table >
Ok, I was kinda hoping for a more "permanent" solution such as: int sqlite3_cast_column_type(sqlite3* db, const char* zDBname, const char* zTable, const char* zColumn, int newColumnType); that would cast the column into the desired type, returning SQLITE3_ERROR if the cast is invalid (like from double to integer, or text to numeric). > Really I suppose it depends on what SQLiteSpy is using to > determine that the column type is BLOB. If you can subversion > that mechanism into thinking the column type is TEXT, then > it should just work. How do you mean by subversioning ? /R _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
