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!
"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
>
>> 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
>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
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
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.
>
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
___
7 matches
Mail list logo