我現在在一項目中碰到這麼一個問題
Sql Server 中image類型遷移到Oracle Blob類型出現圖片顯示不出來,我在Sql Server 中看了一條image資料
如下:
1。Sql Server中
select datalength(d.photo) from drivers d where d.Name like '%陸斌%'
輸出如下
132727
select d.photo from drivers d where d.Name like '%陸斌%'
輸出如下
0x151C32000200000012000C0014002600FFFFFFFF50686F746F20456469746F7220D5D5C6AC004D5350686F746F45642E330001050000020000000C0000004D5350686F746F45642E33000000000000000000005E0100D0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF0900060000000000000000
2。Oracle中
select DBMS_LOB.getlength(d.photo) from drivers d where d.Name like '%陸斌%'
輸出如下
132727
select d.photo from drivers d where d.Name like '%陸斌%'
輸出如下
0x151C32000200000012000C0014002600FFFFFFFF50686F746F20456469746F7220D5D5C6AC004D5350686F746F45642E330001050000020000000C0000004D5350686F746F45642E33000000000000000000005E0100D0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF0900060000000000000000
遷移的資料是一模一樣都是16進位但在顯示時圖片就是顯示不出來,為什嗎???好鬱悶呀