tags:

views:

48

answers:

0
Q: 

Archiving from mySQL to Sybase using Powercenter, problem converting varchar to bit

I have to different databases one is mySQL and the other is Sybase IQ. Both have the same table layout and datatypes.

One of the fields has a bit datatype.

Unfortunately when I pull the mySQL table into Powercenter it makes it converts it to a string(1). Now when I am trying to write the data from Powercenter to the Sybase IQ table using ODBC Driver. It has a problem that it cannot do an Implicit conversion from Varchar to BIT.

Does anyone have a possible solution to this.

related questions

How to format a string as a telephone number in C#
RFC timestamp in Flash/AS3
Cast or convert when retrieving data from a database?
Convert Char[] to a list<byte> (c#)
Are there any tools for converting Managed C++ to C++/CLI?
How do I convert an M4A file to an MP3 or WMA file programmatically?
Is casting the same thing as converting?
How to convert Pixels to Points (px to pt) in .NET? (C#)
How do you convert a string to a node in XQuery?
Converting Reverse Polish Notation
How to convert from Decimal to T?
How to convert a unmanaged double to a managed string?
Is there any built-in way to convert an integer to a string (of any base) in C#?
How do I convert GMT to LocalTime in Win32 C?
How to convert decimal to hex in JavaScript?
Converting vb.net to c# tips
What are some gotchas when retargeting .net 2.0 to 3.5?
What is the best way to convert between char* and System::String in C++/CLI
wav <> mp3 for flash(as3)
What is the best .WTV conversion tool?
.Net Parse verses Convert
Is there an easy way to convert C# classes to PHP?
Generic Type Conversion FROM String
What's the best way of converting a mysql database to a sqlite one?
Most Efficient Way to Test Object Type