Answer by ThomasRushton ·
Converting from image data type in SQL 2000 can be done via binary / varbinary data types.
The following is a bit messy, but it works. Or at least seems to work in my limited testing...
create table testimg (id integer, imgdata image) insert into testimg values (1, cast ('Test row 1' as image)) insert into testimg values (2, cast ('A longer line of test data' as image)) select id, imgdata, cast(cast(imgdata as binary) as varchar(1000)) FROM testimg
This'll return a varchar(1000) field containing the text version of what's stored in the field named imgdata.
Answer by farzad_1354 ·
Answer by hongdida ·