[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Data Conversion: VarBinary to DB2

Posted on 2004-11-02
5
Medium Priority
?
1,268 Views
Last Modified: 2006-11-17
What is the proper way to convert varBinary fields from SQL server to DB2? Should I use Blob in DB2?
0
Comment
Question by:loveviolet
  • 3
  • 2
5 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 12476206
how big is the varbinary column?
0
 
LVL 1

Author Comment

by:loveviolet
ID: 12476225
Actually not so big, it was a stupid design that's using varBinary field to store passwords.
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 12476311
is that the actual password or an encrypted hash ?

ie do you want the data to be converted to EBCDIC or left as binary?  
0
 
LVL 1

Author Comment

by:loveviolet
ID: 12476328
It was the password in binary form, and they still want it to be left in binary in DB2.
0
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 750 total points
ID: 12476396
then i think you need blob...
but i'm still not clear wether you'd expect it to remain the same value as on SQL Server or
be converted to the EBCDIC equivalent (which i don't think would be automatically done for Binary data)

hth
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question