Re: [sqlite] blob api

2008-04-22 Thread Robert Bielik
Igor Tandetnik skrev: >> 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); Hah! Of course!

Re: [sqlite] blob api

2008-04-22 Thread Igor Tandetnik
"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 >

Re: [sqlite] blob api

2008-04-22 Thread Ralf Junker
>> I'm using the sqlite3_blob_* api to write a larger text stream >> incrementally. Works a charm, but is there a way to >> change the datatype of the blob to text afterwards ? I'd like to see >> the text easily in f.i. SQLiteSpy. > >Perhaps: SELECT CAST(b AS TEXT) FROM table Yes, this

Re: [sqlite] blob api

2008-04-22 Thread Ralf Junker
>Ok, I was kinda hoping for a more "permanent" solution such as: Did you consider creating a view? >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

Re: [sqlite] blob api

2008-04-21 Thread Robert Bielik
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

Re: [sqlite] blob api

2008-04-21 Thread D. Richard Hipp
On Apr 21, 2008, at 3:10 PM, Robert Bielik wrote: > Hi all, > > I'm using the sqlite3_blob_* api to write a larger text stream > incrementally. Works a charm, but is there a way to > change the datatype of the blob to text afterwards ? I'd like to see > the text easily in f.i. SQLiteSpy. >

[sqlite] blob api

2008-04-21 Thread Robert Bielik
Hi all, I'm using the sqlite3_blob_* api to write a larger text stream incrementally. Works a charm, but is there a way to change the datatype of the blob to text afterwards ? I'd like to see the text easily in f.i. SQLiteSpy. TIA /Rob ___