Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Converting BLOBS to SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-12-06 : 08:42:47
Chris writes "I am currently converting a database from Interbase to SQL Server 2000 using DTS. I am having a problem with converting an Interbase BLOB field to a text field on SQL Server. The conversion works with no errors but when I query the column in query analyser it looks like this:

2A2A2A2020534F4E2031382F31302F323030342031303A32323A313520202A2A2A0D0A6E6F20636F72702069640D0A0D0A

Any help would be appreciated"

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2004-12-06 : 15:39:50
See, if this helps:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

--Frank
http://www.insidesql.de
Go to Top of Page
   

- Advertisement -