Question

Chowdhury Ashik Tanvir on Thu, 20 Apr 2017 08:54:36


Hello,

I've converted MySQL database to MS SQL Server 2008. After converting my Database I am facing a problem from my application which was developed with PHP - MySQL.

Problem: When I open any attached file from my application it is opened with different numbers. For example, when I open an Excel file It shows me the following number:

0xd0cf11e0a1b11ae1000000000000000000000000000000003e000300feff0900060000000000000000000000010000000100000000000000001000001c00000001000000feffffff0000000000000000fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdffffff1f000000030000000400000005000000060000000700000008000000090000000a0000000b0000000c0000000d0000000e0000000f000000100000001100000012000000130000001400000015000000160000001700000018000000190000001a0000001b000000fefffffffeffffff1e000000fefffffffeffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff52006f006f007400200045006e00740072007900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000500ffffffffffffffff020000002008020000000000c0000000000000460000000011e97de326dfd00120b46255a39cd2011d000000c00200000000000057006f0072006b0062006f006f006b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001200020104000000ffffffffffffffff00000000000000000000000000000000000000000000000000000000000000000000000002000000fd320000000000000500530075006d006d0061007200790049006e0066006f0072006d006100740069006f006e000000000000000000000000000000000000000000000000000000280002010100000003000000ffffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000f000000000000000050044006f00630075006d0065006e007400530075006d006d0061007200790049006e0066006f0072006d006100740069006f006e000000000000000000000038000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000000400000008010000000000000908100000060500a91fcd07c980010006040000e1000200b004c10002000000e20000005c00700009000062616472756c2e69742020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202042000200b004610102000000c00100003d0106000100020003009c0002001000190002000000120002000000130002000000af0102000000bc01020000003d00120078003c00883b4920380000000000010058024000020000008d00020000002200020000000e0002000100b70102000000da000200000031001a00c8000000ff7f9001000000000000050141007200690061006c0031001a00c8000000ff7f9001000000000000050141007200690061006c0031001a00c8000000ff7f9001000000000000050141007200690061006c0031001a00c8000000ff7f9001000000000000050141007200690061006c0031001e00dc000000080090010000000200000701430061006c00690062007200690031001e00dc000000090090010000000200000701430061006c00690062007200690031001e00dc000000140090010000000200000701430061006c00690062007200690031001e00dc0001003400bc020000000200000701430061006c00690062007200690031001e00dc0001000900bc020000000200000701430061006c00690062007200690031001e00dc000200170090010000000200000701430061006c00690062007200690031001a00c800040014009001000001020000050141007200690061006c0031001e00dc000000110090010000000200000701430061006c00690062007200690031001e002c0101003800bc020000000200000701430061006c00690062007200690031001e00040101003800bc020000000200000701430061006c00690062007200690031001e00dc0001003800bc020000000200000701430061006c00690062007200690031001a00c80004000c009001000001020000050141007200690061006c0031001e00dc0000003e0090010000000200000701430061006c00690062007200690031001e00dc000000340090010000000200000701430061006c00690062007200690031001e00dc0000003c0090010000000200000701430061006c00690062007200690031001a00c8000000ff7f9001000000020000050141007200690061006c0031001e00dc0001003f00bc020000000200000701430061006c00690062007200690031001e00680101003800bc020000000200000701430061006d00620072006900610031001e00dc0001000800bc020000000200000701430061006c00690062007200690031001e00dc0000000a0090010000000200000701430061006c00690062007200690031001a00f0000000ff7f9001000000020000050141007200690061006c0031001a00f00000003700900100000002008a050141007200690061006c0031001a00f00001000800bc0200000002008a050141007200690061006c001e041c000500170000222422232c2323305f293b5c28222422232c2323305c291e04210006001c0000222422232c2323305f293b5b5265645d5c28222422232c2323305c291e04220007001d0000222422232c2323302e30305f293b5c28222422232c2323302e30305c291e0427000800220000222422232c2323302e30305f293b5b5265645d5c28222422232c2323302e30305c291e0437002a003200005f282224222a20232c2323305f293b5f282224222a205c28232c2323305c293b5f282224222a20222d225f293b5f28405f291e042e0029002900005f282a20232c2323305f293b5f282a205c28232c2323305c293b5f282a20222d225f293b5f28405f291e043f002c003a00005f282224222a20232c2323302e30305f293b5f282224222a205c28232c2323302e30305c293b5f282224222a20222d223f3f5f293b5f28405f291e0436002b003100005f282a20232c2323302e30305f293b5f282a205c28232c2323302e30305c293b5f282a20222d223f3f5f293b5f28405f29e000140000000000f5ff200000000000000000000000c020e000140001000000f5ff200000f40000000000000000c020e000140001000000f5ff200000f40000000000000000c020e000140002000000f5ff200000f40000000000000000c020e000140002000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e000140000000000f5ff200000f40000000000000000c020e0001400000000000100200000000000000000000000c020e000140005000000f5ff200000b400000000000000049f20e000140005000000f5ff200000b40000000000000004ad20e000140005000000f5ff200000b40000000000000004aa20e000140005000000f5ff200000b40000000000000004ae20e000140005000000f5ff200000b400000000000000049b20e000140005000000f5ff200000b40000000000000004af20e000140005000000f5ff200000b40000000000000004ac20e000140005000000f5ff200000b400000000000000049d20e000140005000000f5ff200000b400000000000000048b20e000140005000000f5ff200000b40000000000000004ae20e000140005000000f5ff200000b40000000000000004ac20e000140005000000f5ff200000b40000000000000004b320e000140006000000f5ff200000b400000000000000049e20e000140006000000f5ff200000b400000000000000049d20e000140006000000f5ff200000b400000000000000048b20e000140006000000f5ff200000b40000000000000004a420e000140006000000f5ff200000b40000000000000004b120e000140006000000f5ff200000b40000000000000004b420e000140006000000f5ff200000b40000000000000004be20e000140006000000f5ff200000b400000000000000048a20e000140006000000f5ff200000b40000000000000004b920e000140006000000f5ff200000b40000000000000004a420e000140006000000f5ff200000b40000000000000004b120e000140006000000f5ff200000b40000000000000004b520e000140007000000f5ff200000b40000000000000004ad20e000140008000000f5ff200000941111970b970b00049620e000140009000000f5ff200000946666bf1fbf1f0004b720e000140001002b00f5ff200000f80000000000000000c020e000140001002900f5ff200000f80000000000000000c020e000140001002c00f5ff200000f80000000000000000c020e000140001002a00f5ff200000f80000000000000000c020e00014000a000000f5ff200000f40000000000000000c020e00014000b000000f5ff200000f40000000000000000c020e00014000c000000f5ff200000b40000000000000004aa20e00014000d000000f5ff200000d400500000001f0000c020e00014000e000000f5ff200000d400500000000b0000c020e00014000f000000f5ff200000d400200000000f0000c020e00014000f000000f5ff200000f40000000000000000c020e000140010000000f5ff200000f40000000000000000c020e000140011000000f5ff200000941111970b970b0004af20e000140012000000f5ff200000d400600000001a0000c020e000140013000000f5ff200000b40000000000000004ab20e000140005000000f5ff200000000000000000000000c020e000140014000000f5ff2000009c1111160b160b00049a20e000140005000000f5ff2000009c1111160b160b00049a20e000140015000000f5ff200000941111bf1fbf1f00049620e000140001000900f5ff200000f80000000000000000c020e000140016000000f5ff200000f40000000000000000c020e000140017000000f5ff200000d4006100003e1f0000c020e000140018000000f5ff200000f40000000000000000c020e0001400190000000100200000080000000000000000c020e00014001900000001002000006811114020402000060920e0001400190000000100200000281111402040200000c020e0001400190000000100200000281110402000200000c020e0001400000000000100200000201111402040200000c020e0001400190000000100220000381111402040200000c020e00014001a0000000100200000280111400040200002c020e00014001a0000000100220000380011000040200002c020e00014001a0000000100200000280011000040200002c020e00014001a0000000100200000281011002040200002c020e00014001b0000000100200000280011000040200002c020e00014001900000001002200007811114020402000041620e00014001900000001002200007801114000402000041620e00014001900000001002200007800110000402000041620e000140019000000010022000078101100204020000416207c0814007c0800000000000000000000000051008b758e757d0828007d0800000000000000000000000043000000010004001400030000000000000030305c293b5f282a7d0828007d080000000000000000000000004800000001000d001400030034d30000000030305c293b5f282a7d0828007d080000000000000000000000004900000001000d001400030034d30000000030305c293b5f282a7d0828007d080000000000000000000000004a00000001000d001400030034d30000000030305c293b5f282a7d0828007d080000000000000000000000004b00000001000d001400030034d30000000030305c293b5f282a7d0828007d080000000000000000000000004c00000001000d001400030000000100000030305c293b5f282a9302120010000d0000323025202d20416363656e74319208300092080000000000000000000005041eff0d0032003000250020002d00200041006300630065006e0074003100000000009302120011000d0000323025202d20416363656e743292083000920800000000000000000000050422ff0d0032003000250020002d00200041006300630065006e0074003200000000009302120012000d0000323025202d20416363656e743392083000920800000000000000000000050426ff0d0032003000250020002d00200041006300630065006e0074003300000000009302120013000d0000323025202d20416363656e74349208300092080000000000000000000005042aff0d0032003000250020002d00200041006300630065006e0074003400000000009302120014000d0000323025202d20416363656e74359208300092080000000000000000000005042eff0d0032003000250020002d00200041006300630065006e0074003500000000009302120015000d0000323025202d20416363656e743692083000920800000000000000000000050432ff0d0032003000250020002d00200041006300630065006e0074003600000000009302120016000d0000343025202d20416363656e74319208300092080000000000000000000005041fff0d0034003000250020002d00200041006300630065006e0074003100000000009302120017000d0000343025202d20416363656e743292083000920800000000000000000000050423ff0d0034003000250020002d00200041006300630065006e0074003200000000009302120018000d0000343025202d20416363656e743392083000920800000000000000000000050427ff0d0034003000250020002d00200041006300630065006e0074003300000000009302120019000d0000343025202d20416363656e74349208300092080000000000000000000005042bff0d0034003000250020002d00200041006300630065006e007400340000000000930212001a000d0000343025202d20416363656e74359208300092080000000000000000000005042fff0d0034003000250020002d00200041006300630065006e007400350000000000930212001b000d0000343025202d20416363656e743692083000920800000000000000000000050433ff0d0034003000250020002d00200041006300630065006e007400360000000000930212001c000d0000363025202d20416363656e743192083000920800000000000000000000050420ff0d0036003000250020002d00200041006300630065006e007400310000000000930212001d000d0000363025202d20416363656e743292083000920800000000000000000000050424ff0d0036003000250020002d00200041006300630065006e007400320000000000930212001e000d0000363025202d20416363656e743392083000920800000000000000000000050428ff0d0036003000250020002d00200041006300630065006e007400330000000000930212001f000d0000363025202d20416363656e74349208300092080000000000000000000005042cff0d0036003000250020002d00200041006300630065006e0074003400000000009302120020000d0000363025202d20416363656e743592083000920800000000000000000000050430ff0d0036003000250020002d00200041006300630065006e0074003500000000009302120021000d0000363025202d20416363656e743692083000920800000000000000000000050434ff0d0036003000250020002d00200041006300630065006e00740036000000000093020c002200070000416363656e74319208240092080000000000000000000005041dff070041006300630065006e00740031000000000093020c002300070000416363656e743292082400920800000000000000000000050421ff070041006300630065006e00740032000000000093020c002400070000416363656e743392082400920800000000000000000000050425ff070041006300630065006e00740033000000000093020c002500070000416363656e743492082400920800000000000000000000050429ff070041006300630065006e00740034000000000093020c002600070000416363656e74359208240092080000000000000000000005042dff070041006300630065006e00740035000000000093020c002700070000416363656e743692082400920800000000000000000000050431ff070041006300630065006e00740036000000000093020800280003000042616492081c0092080000000000000000000005011bff0300420061006400000000009302100029000b000043616c63756c6174696f6e92082c00920800000000000000000000050216ff0b00430061006c00630075006c006100740069006f006e000000000093020f002a000a0000436865636b2043656c6c92082a00920800000000000000000000050217ff0a0043006800650063006b002000430065006c006c0000000000930204002b8003ff92082000920800000000000000000000010503ff050043006f006d006d00610000000000930204002c8006ff92082800920800000000000000000000010506ff090043006f006d006d00610020005b0030005d0000000000930204002d8004ff92082600920800000000000000000000010504ff0800430075007200720065006e006300790000000000930204002e8007ff92082e00920800000000000000000000010507ff0c00430075007200720065006e006300790020005b0030005d0000000000930215002f001000004578706c616e61746f7279205465787492083600920800000000000000000000050235ff10004500780070006c0061006e00610074006f0072007900200054006500780074000000000093020400308009ff92083a00920800000000000000000000010209ff120046006f006c006c006f007700650064002000480079007000650072006c0069006e006b0000000000930209003100040000476f6f6492081e0092080000000000000000000005011aff040047006f006f0064000000000093020e00320009000048656164696e67203192082800920800000000000000000000050310ff0900480065006100640069006e006700200031000000000093020e00330009000048656164696e67203292082800920800000000000000000000050311ff0900480065006100640069006e006700200032000000000093020e00340009000048656164696e67203392082800920800000000000000000000050312ff0900480065006100640069006e006700200033000000000093020e00350009000048656164696e67203492082800920800000000000000000000050313ff0900480065006100640069006e006700200034000000000093020400368008ff92082800920800000000000000000000010208ff0900480079007000650072006c0069006e006b000000000093020a003700050000496e70757492082000920800000000000000000000050214ff050049006e00700075007400000000009302100038000b00004c696e6b65642043656c6c92082c00920800000000000000000000050218ff0b004c0069006e006b00650064002000430065006c006c000000000093020c0039000700004e65757472616c9208240092080000000000000000000005011cff07004e00650075007400720061006c000000000093020400008000ff92082200920800000000000000000000010100ff06004e006f0072006d0061006c000000000093020d003a000800004e6f726d616c2032930209003b000400004e6f746592081e0092080000000000000000000005020aff04004e006f00740065000000000093020b003c000600004e6f7465203293020b003d000600004f757470757492082200920800000000000000000000050215ff06004f007500740070007500740000000000930204003e8005ff92082400920800000000000000000000010505ff0700500065007200630065006e0074000000000093020a003f000500005469746c659208200092080000000000000000000005030fff05005400690074006c0065000000000093020a004000050000546f74616c92082000920800000000000000000000050319ff050054006f00740061006c00000000009302110041000c00005761726e696e67205465787492082e0092080000000000000000000005020bff0c005700610072006e0069006e00670020005400650078007400000000008e0858008e0800000000000000000000900000001100110054

How can open file in exact format?

Note: In MySQL the data type was longblob

           In MS SQL the data type is image



Sponsored