I'm using a DBI::ODBC on Windows 2000 and connecting to a NT server. I
'm trying to pull data out of one db to insert into another, using the
"INSERT INTO" command. All of the data copies fine except for a
binary(16) field. For this field I've used the bind_param as in:
$query = " INSERT INTO Types ( id , nickname )
VALUES ( ? , ? ) " ;
$sth1 = $dbh1->prepare( $query );
$sth1->bind_param( 1 , $row[0] , SQL_BINARY );
$sth1->bind_param( 2 , $row[1] );
After a lot of fiddling this works. There are times when it is more
convenient to convert the binary to a hex representation. When I do this
it is misinterpreted as a CHAR and does not store correctly.
Is there a way that I can use a CONVERT call or a datatype binding that
will allow the hex representation?
Thanks for the help.
---------------------------------
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices!
