December 13, 2005 at 6:08 pm
I am working on an SQL database and the database was transferred over to another database, and now some of the information that is saved as \\server\folder\ is not in human readable form.
Is it possible to get this back into some sort of readable form? the information that is saved there is the link to the file, which appears in hex format it looks like when just viewing the table.
I have tried
select convert(varchar(100),convert(binary(100),textcol)) as test
from databasetable
this converts it, though as some I suspect got corrupted, it shows up similar to *%*$)# and can't read it.
Is it possible to convert this information into readable form?
December 13, 2005 at 7:38 pm
I have determined that it isn't actually corrupt just cannot be read in SQL Server.
How do I check the contents of the image field, to determine what the link is and resolve the problem so the information is again displayed as normal text and not gobbly gook?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply