"Robert Bielik" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> 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);

Perhaps

update tableName set b = cast(b as text);

Igor Tandetnik 



_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to