Sign in
 
Home20122008 R2200820052000LibraryForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server >
> 
> 
SQL - Oracle migration: conversion fails for Binary datatype

回答の候補 SQL - Oracle migration: conversion fails for Binary datatype

  • Wednesday, February 22, 2012 9:21 AM
     
     
    Sign In to Vote
    0

    Binary data type of Source (SQL server) gets converted in RAW data type (Oracle) which changes the data value in the target and doesn’t get matched with source system.

    For example: In SQL server data is ' 0x00' after migration it's 0 in oracle. Similarly 0x40 get migrated as 40.

    Any idea?

     

All Replies

  • Wednesday, February 22, 2012 1:38 PM
    Moderator
     
     Proposed
    Sign In to Vote
    0
     

    Hello,

    The following SQL Server data types should be mapped to the “LONG RAW” data type in Oracle: image, binary and varbinary. So instead of RAW use LONG RAW.

    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com