Create image from image field - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Create image from image field

Author

Topic

lisandro_cm
Starting Member

3 Posts

Posted - 2011-07-18 : 16:08:47

I need to get images out from a sql server 2005 database, the application table has one image field, I've tried lot of ways I've searched but cannot get a readable image.

Looking at the data, I believe its encrypted or coded, because normally all images I've tried saving and retrieving myself were stored at the database with the format "0xFDD....." and all this images begin with "0x789..." any ideas?

The table:

CREATE TABLE [dbo].[ASSINATURAUSUARIO](
[CDUSUARIO] [int] NOT NULL,
[ARQUIVO] [image] NULL,
[EXTENSAO] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AI NULL,
PRIMARY KEY CLUSTERED
(
[CDUSUARIO] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF

An image field data example:

0x789CA5BB0950135B17EF1B651219C23C0A514150015199044322A22222C6010541888A328A1C152462480484304745444108C8A428E4A80CCA9000097010350C020A42261510906E995AE82437E7BEFAEE57EFD5AB5BAFDE6D6A1755DDBB3AEBBFF7DA6BFDFE54907C96F0106A870EB81F40AC5AB50A7156FA8390F0113AFB09A1410884BBFB56C41AC47F2EC908C2F5DF59FF47D7BF2FF93F7DC72A490B427D0DE2D62A84CCAA8D88D5EAAB64D45749D8081402B14AEEFF9AF09F9057AD969195935758A3B856493AA1560DB17A958CCC6A591939395959E9D338E97384ACBA9CC6861D2EF29AC7CE296CBCA2B533FE6EF11A93BD2F5BB58FF702A636E7AF2628AED5D1D5D337D86466BE79CB565B3B7B875D8E4EAEFBF61F703BE87EE884D7C953DE3EA77D032F5C0C0A0E090DBB16157D3D86702336F1765232252535ED5EF6FD9C07B90F1FE53D29292D2BAF78FAACF2D5EB9ADABAFA376F1BDA58ECF68ECE7FBADEF5F57F1A181CFAFC65982F107EFBFE637C62F227F87B6E7E617109FAB3FCAFAE7F75FEE7FA7FD5A52ED5B55A56564656E15F5DAB56C7FC3B415D566EC30E790D97630AE7AE686EDC19BF466BEFDDE297AD8A2636C701EDF3577BD7EA98DAF23781FF4AFB9FCAFEBF094BF8FFA5EC7F09FBAFAE6184B2CC2AE9E6C9A823B008B178F39334C47F4706F5D81E39ADFF8C0BC614DBA3ABF66B7D10F68869C2FD830D33CC5CFA59D47EAD7F6FFE6F870CAA685982700DD8019A0B729349467848C67D7061D461FF27C60602EB3040A6586D1B41D2C3FA32B99F970F6504B97E74D76FDD853058D44F5DAFB19D20AE85EA2508398D7ED246D84554C4D0F681CD72A7190EA202922CF19CA884E8B0E8E75219E644A3626B61E72248D7CD60C39F876476AEFF5EBC32B91E33A1C7A960F9ACC35C2C7861BFE169E783887731C7D2BC2EF0CDBF7F2CCAF7BE7EF9DDAFA9B5B3A375CDF353DFFF48100745F959D3DB5BD1243C5EFC371CF7333AE734018DBC2C41E03B98D85AFA0872DF1B110DA346DC079CCC27E476726B54A9E5C3F036004FF1C1FF34A06445376FBA38A8BE7887C562A881EA21F01541B431FE76A0F7DCDC9D0A8E04710E9F7697E0B048022F53C1C4CE1E09221236851A416C2B0303EA66C2FB4BCBED9C517E715702B63894DBA23409377D8CCD8128328165AF1A2347AA60DDA02EC61DEEF2FB4A9FF6B29EF59C3B5D2B3FDBA55F617CBD79728B9F57F6F7E58FA921D90313F3C35C5A9C0EFDDAC2EAD3C4A675C08E2EA31BE6BF3915878EAD972DBC313933B2C2ED636E87A357E2089D2EC01788F284C4293421531C7C398B38CA65F1460255AC3D94C530B599CAD3492F42269195A8C94DA7056435A456DD1B341DF2D06DCDD0F666A8C4E104F4611356A11C64554AC483E29C67D089956BACE123B5E1BCC6EF32EC8A538335517958F98CB328B5E73B8E6EDFFED345E6324EEB8DB723EBA927AB20A876DDE6AB6F3E34DC7D757F63B1597FD6CBBC7BD4D757B2699681D1030B49B57DA7A6223443A72AB907F29AE70F2E9FBED84110BF5D9EEFE485A25B27DCFE2C0FBD93205498A14C15C2D0E2E57E72C89408791CA027FD9AF7F466071F6A6A30C82ABB5836B1DC3D51ED5359F91A65F95A6EADEEF5837F5E9112F11AA1E687FB17DC2F57CD4C47E3A699D3E50D912FAD84E1969403D4ECFB415FE5BF5EC91C7139637C085A77C478F108F8F859632917EDE855F56EF8FAE58F1FA722F46D7728326F8EF5628F3C7FF2FA156318FEB57CA35C3D9E33F5296BFCD39521E3F2376439780F50C18ED38328AD06838F047864DCEBE3FD12446DCD737A7DBBA8B8F41F75E171CC9C4A59DDB8E3669BB9416F3659CF07DACD9720B2D057E21CBECC4B10F2902B9BB1B9F94AAB1329E98951C447E4E1ADF18F63B0C7E668D3E4A249942CF3022D190BDCED2A275CFE4470156B7275FC476FC4920ACE59671AC12E5B0695E40D13C35D8C7CD6D9BAAD0FB4AB43A9BED48F65D3B3AE666CD06ECC3E827B3260B1A9E4F515BC96202DBA8F31BA50377C639EB11C6BF622AEA9D2A6EBDBF5D64ED92578AB52AAEC0D6C16E656F4BC2C40A0A7E266BE00BBA60CAEE74810BA88495D078F5009421166AAC0E7CE01633D7FCE1A05E00CC39D546AFF06FEECCE693AF862F07BB2E8B323EAA2EF58EBF361972BF2DB2C2FE73A6212CBAF7C5C35D5AF5D7058D5425968E97BCFF3B9BF1D89515F7F33AAF1E58B8800ABF65FF50D8C5467F1AFAF83A385A867A45E263202C51E6C383C660AD63DE775D3FF86B20F42A13CAE1EBCEF5394E8E83A09E2420D695D8F39CE46E6E9D53DBC4B337343B7C861B8549283A8F485588903B8F902010912846A2D36C57B783CBD0957FA4170975F1E5834F1A241FEB6693A4B1C9C32B21AA545A8227A35A2F76DACDB9FE91517C3C326635421BF920F45106A7F6DCFBCE1073FAFC15FD355F2AB3ED5E61E33410A5ABF26DEBB92D371C35C10F945E1D8DF207DC664E53AA10977E51AB98C8807982CEC3C0FC33D574640B6BE7C1DEAB4A5D36035947E66C877478BA53B36E6EA8A7EEC3BC633DA87EF3F491FEFC7151CBA772FACCCED481ECDF24CA0A9A8A4F14AB6A7E98BEFEFAFE2F50AEABCEBD22F54452C04A40D4FF59ACCC77E3CF7FDBA183FFE87F6D4EE7C283BD0049620161AAE57BEFC47EBAC3475B07409C22F8F3273E7908204415F10CE4D7EF27EDF41B7399539D0D71B9233D310D4ACBD3435225659D67722A744399F179EEAAF5959F1481F95074E430983C3DF9CC7A84F9B3C9E5B1EE705FF18D35396330935CCF1773B14247B36438CE285F3B0898CED6F13177B4574D81818215F18866EF2F0190F7E0DE98BFB22E5EB92AA549BAF5766673C96E1DA0D07887B59ED6318F26D0942D6F60F3154A062E943D523BAFB7931A0709E7F6701EAF4908617150F9A9629A7F2E9CABBEE61B7BFEE5A3556D25B755F50E6EFA1FC27709A7F9CB86CA7BF5723A2E2C28B42A655ACC9C8F32FA7A72ED635EB0E63980E16EBC63C10073967C4464E42148EFDA99C20BA029153E9AA5019B653C91FF36E89F70DAF3AFB2B2238F0F90409D334682B41D4CB2B3C5CC8441C6C304DBDD5DDB045D754D95E4099B3582C86F25722218B4EFC6B5CF2890ED49A288F5963F8409F622F6CC0D805742EF650BD7B4E9CE9B5AB3A8E57875EAF04B246EC9A76961ED3F9E9520D53D757159C173FA7BC0F39802B10FFBE925EEB74B974D9D123677FFD85BEF4AB574F5DB948741BB8D7B7F4BDDFDFCE03EF311250EF4BABDD1BB98BF44D6C5EB1D02941BC887E96C39AA7D39AEC4958FFAF7FC636A3D6A8D2E2A9D3F142D40C1A15B3819448BD94B6B8DB3D52A0C758D932D9FE54883DC21437AD783F0A4860BD35FD94779D487F6456BFF4824EBF575FD0BE90145533094910239DAEFB83E3AA510EFF7096DD8618B1C1B0E8E6C0C3A03932E78F901ED6555EEF193B11F540DAF7F7681DDB8FF8CF38498BDC49FB7356115E16E7FCCE4D122B84EB481035DC766B6AA1C940CDE8012E9BAC0A5B01CC3603FFA7262B0EAC3CE397D584443FFF089A7E30A8DC9D909FFB606F6BBCEF72FFD9056C05E4658C17D9074A10AB509F06FAE878D5D2BF27038E7DCF8E7866175DB63430557264F14F3E4A1EB617DD156B90DE0F2F658AAD26F2E81915FD51A386ED43C36E143BAA9AC753C8826F9D5C3B9ECEC66A469193F2D42F18A3705A53C31B40BBE15B23E55B537EAAE7306C20473EEEF672D962F14A18F11450D72840A6A08CD0379F1138BC8A56BF7DC6269F5CF6E499C7DB652AB54CAF66B27581C114F461F11610834C1862ABA69BEE44B0162B4EF54589828F30FA66797EF92A47065ECC46F824D49FDA77B6F89B3A3BE3ADC263213A03EE07708B7B209915B4DD776EDBEC6A97D2B0BC462DE650749CB73F689EF2C834E399C181D7D553FD4672D71BE571AA7A265FAF255F3CCE5850DDB4E883EE606C2B737BE4B578E56A5655AFFBA1A3D78EA7A73DFDEA55A6F776D768C0DCB5ACB5091339B3D1B5D5D30F1ED7F5FB454C95D1BE7B7746EABBF12387B98BD7A0472B47A1D79E40D56CF23C5E8BF0B1BB05B3AE76B0E9C08358AF86572124598042A9B90D7061D3B18DD0ADE8A55360CD9D97FAEF9E2365B6744EA854B4CD6A12AF029C0CF116A86EE4642F3142682D03CDB1F0724D5682292BA716A23DF0B1B9742A6FDBDDE75306B6498B10A5FD7CDC5ABCDEC6A667DFF7F357A27D1E7CBDBF3CE70D45F03223DB4928B0FA253F13791C8C49D6F4AE036653ED3CB73ABB9DECB18CAEA278A7EF1BF0B1CC331F465C78B7DDD4AC77A9DEFA7A84D7FE9483C7B1B97A98CFE8C0DAEB3FD0E75F3E3C43FFF9D2ABE2FE3946D507D97B5EA3EE9FAEDC3E9EF1643CEA679D0441E06B771B9D792B7E3250DB9F9FEF079FF2A82D7831FD82D93D27237068C5694BDB9FE24D012D716C8B5A28C31A204F2F547E1EA3297E3572BDFC8C3FAA37753B24638FB9B99B9C826BF2C57F5AE9D97466D80737C178825816F607E40493CCD7B9D35382C8F841B216D14F60685331C970048752ED240804B4F158D1EB8BB92C9A92ADCA355FF04CA1B9EC96BF1EEAEDB75B19B9762E3C26C2B9E0BDCEDCC81930FA92CBB06BA063271AF8ABF5889B7C53AE3FA40FB0D828A56872A2EE9812B0045B1845B2AAF8F99C35C3A1EE15A1B42F974AF5DE99FDA59BACBFEAF72A4BD2A5B98B302E81E5607971B3D7E3973655B3013BA883DABBBCAFF83282554907DFDA966D321D78928B7B79AAAE3BC7FC354432F26DF0AE6B9CFF045988D75A83D5CBA844D246481BA81E683A013A74161A4584B3038C7AAEFF742A4C0762DCAE3950D17B74D7FEFC4D20BB9FE37DFE7E12639D13B0AB67C3360962B3F833B3F64823485BBC0C3AA4311409BB8FF762839814EF427907A61A31BC84A65A41B53B351465A5B91F484EE5659236371DB6452AD7351613AAE0132F7549092715F4238750B72488574B6DB82F5C56FD329235637122BCEAB0D007F44EB7BE00A2326B1785A811F186C19C115F9304FD5B0187788FB5A718364443A0B36336A9D016C209B03BBB5963DB7BED54F4AB6BBA7D3A4A4AF4E351C3B17BD61ECCB31F7E77423F688D1EE59CFF8D18F58BFAF6365BA3AE72C2A72BDF56E6446EDAE2E9F2B1E275660E5FABD8E5DDF1A3314F05C30967DEA4E9BD0DD7C9E9EB3D6DDBE85012D3CB68A88A09FE88AFF57F70B792285B03A1022B27137D202993ADA967A190A1E408D4644350E37388BC6F28DB0DF1C07F157A7B34E5EC017BA79D8F77C8FC325AFB8E7BB86FBA6684BCE014FD6A1811678290B91397457AB3444F63AC15777A072842F191A0B780D3EE891752D8285502A6B385B47AA016AF426E73282318B2DC37D6D03E37A881A874F5A6FD5BCEF7131E95BA9FD1950D7C1FB5F26417E9E4F48ECE8AFE21858AFA66C2E97273E4B6C3CE8A0DB9F72B1D7FBF093811313D7837C3F4C1BB99AE79170A4BF0D787BA5F359EFECEF77E36FE9C1FBA70776EBC039F46562319F8922F495BEAE25B10CBF28D481C23A4365908548C889E1573494EDB12AB6ADCF067911B4C53DF5CD2EEEC86FC573062AE0AB022F09EA10870493419740468C012E03B38AB0915EE40355DE0ACCB2239BE067159351A994F68B29B417CAA8B04719BBA7FC8EF174F3DE7583D75D2DE65E5BDF155B76FB843F06F881BBAB2CA97C0F47E0D09F938299CE6FE7C56C60D5B72AA8FB7F377F56238592F82BD763183F34855C7AFB411DFB1410DDE2353D97347A9657CCB6EF30C1BB41936D922F8F25F1572D3E629278E674C7E3A7EA57833CE7DEF57F0BE237DFAE781A3B1959F632E489BD05B7C7B7077F9B045636CC8F4F47CF03BBC16330C35D2E8353013F51A39BDB4623BF9639A7C89403E24CDEB192C486265313F0720803E285881EE383E92B72CB3E80985C609E91A67A4CEC57BC61B3C21184A9F37CC0E7D0E6D56C1F39949355687A3A97E908F4F04711D75BBECB9DE546585A721F85AE4B42B206E53422109B45663C3FE155FC235FE586D850C1482D13FBAC6981DA8FF21D87D8524EEC8BB28620F929C9A22FCBC5416BBE699C91284866A719C287D4486E5B841DE4BFEB2CBEEC475EAD383A77F5858122C9FDF9A6BCA1F3D9643F816397CCA3BEDCAB5C75BBD321D5E64139E75D9AD19EB0BC24E73E7741F750D0F7EA9A696788F783D18B5AE67932C079A3608F1D066CECC06205880A2DAE16589E6430C43D804DCC62C1F9D1A6FED060D4F0201D94575492575B5D50F4BC92AB983B59437B8355DEA39771226DA7DE22ACC67982BDAB0765D3D70201D546A3B951793342D6E17E500FD070760377ED51AA467388B619CCDB21852F8C1B92ABF03AF3A22EE25BFF44EC586CCA6930D9B2E3E817205499D1968671E560132643548102D2F9F662A78F4DA7A9B9CE8A152CFA693DE0AC8EA8CBA97052FFF99D2508CB97C875948FC4B5421D6203005DE6D5443E24E6623404B8477045786C4D0D612AF00167E0368CD8B95E488D5C410A2A6D419A588D5803628BD8DB2CB780BFFEAF5081EB298055CB6B6EBF8FEF04CB02A681AA8BAAEC2F1F74DA7B0B2B0A8F32357A3CCDF97F6950F3F0E263C7DB65289CC11FCF55C53DC753D6769B272C076A8AA30F76634BEEC2FF1682C2E23EA00886A8B4CC01B3491F92B1D1D99C2DD1C859F52B7C0D0FBB945F454BB365E88575F1F02DB1F0CC26CC22B36A829052F65947C9362155D18F1205D38FB25BC3357AC67B0AD1988116093D1645067E464539F9D1940BD458CAE62DEF2BE1612B9E13A884B59BBEDF797F3B7F9311101B8766C0D67FA9880AC4460BA40D9A0AE50A1DDC8BB0363F029CA8FA93D46D85FF361B7F4ACA5EEE8C1FB0107328B906B8D14BE7D23B76D56DA9DF836F73AFF5D08B6C66D5AFD19D108546863A691B642BDE0BB25811996EF04250AF114A72F6047D376E6E7F85A1A722B12495B9B58B295FF52FD24F971E3C66B17D7A1D2BAAF1C6D3FCA2F34B9DF0C7DD4FA7DE3CDD34F0915B6155B5A4F1E4B3AC46C2A70B2797CDFF1DC91DF79AD41486D8BB07BE102FFBC70F0555D73EC57D1FB46B08272C9ACBE7F363AC27EE4E827CB68CFB06ECFC681C0FED959DB5165DA4CC1B9C09D3666E96B863BF61606749AAF9BC1E534D90825880CBCF182FFEE0E6385A11A7C3219517DCADD365227730BDA1D34111817E615BE2939256E0715A427E5EFA655FCC903597B99A95515B9AAED39AE0728DF395F848B451244C255D8AAC7FA1C804D23BA954FADEE393D15BB94495404B3D963BB3E399FF01DF263156E766CDD4DB43F7DF250C279C7965AFEAC8104D1BA0376AEFC2018B14E0543968F94443F9D52685D1E7C09DE3C0C45983DABBA556543D03D73127818B3FEF556D77537BB460CCC107F900BC1DAB982D77A4D8D29715D6E5FDE02534FF3A708D7DEF4F77579E5B87FC1C66EBF9746E2E072DD26B9DEF47BC3938535A46D84412C35C008A860E151D073212AE1D242DCEE36A65E49EE21E8622514D3BA343CEFF465674164CBA2581354C698B92753534E5F2EDA3175CC63C3F9195972A97D690AE1E79EE568542E14C45C8BD944FA2CE5106C10396D086FC8580BBB415740253E99BD1BB79610298869C5CB8619E852E063C5E5A912C47A5C6A80D299C03339D8BA6147F4E68AB62BB697A8DAACDD4EEDCB77010962F185A80063365988FAD4B401A4F31F1463532D195F4A43B708ABD672BC729C5593ED7E3CBE73E3A2CB3D55974B8F6F7C75CB0DDAD176F1616D8ED395FBDECD9B1B4EDC2FE2DA3C4706EBEFBD12FAA5EBEAC775F76E8FD79C42A95B3A7D6FDF6D3F6B18FE8E669199D738B81235B2FFDACF0D3DC17D691FD342B0DF939DC8856F3B8DDE2E2F3D13F731BFA1407AAEFB2229F652CC68DC0A19BF7340DB778B0B8A8E1A9F43A59426FF5294203E157C9DEF70147B25FB3E49DB8C78F29C3302886BFF74837E8BFF889E34C9800AED185529E7C9804382CE6434F67A9D6F3015761458234397F1E94F2CB22B43C4972CDB74F5833E763A9AEEA42364E6D3D2E0C7D87ACE4CD8B5EFE4562B66A8BC0471B393B416BB62FD7B41BB588250195FF125F7596343F0F02EAEB20401552244279E302D98FC4672386779FF6C271E76222B3FC3F2DF4A109770CBFB999D3878B704A1CC84F22C1B572D97ED27F9BAAEFC25FE9CED3A4E66D119F6AA253202098285FA5E5F71A46539FAB937AA8E3993AA651C85020E4766D4EBEA4910D4736022FFCEB9D98437E39393FBEF7DF1417E5246BAFC39163F81DD80CF99237D25D765ECE2C01A2302AE18454F64F6325173EFC9C008B78E26DA382E9815A322932408382827F7E2D2BAA538A9D79F3459C006C6924AE090E131DA5309C2006EA02E7E15D51A8AAF5C03DDC9BF78621554C5D91B6512443247F4B6A9491AE073C6E671F1472C8F738479539F239C7D7C6C21AE79B0D121F2F7E4B7E3F97E9BA0E598DFD8A3E753562D5F11936DA0B5AFF10F64163F89DEC86CA18915AF811B95AE255C365CA44276F5B80D7BB0C32DEADF17CD7385899CF7A6B98BBDA23714582014382EA16A502CFC14BF1F8A9D3B9CBD80FC6749445E1E38EE6F3F7614CDDBE656C631192992252791823EAC5C207DEDBE1B2941C8D643E968E657540DA7F516D6188B9147F655B156F0A4D1D71829B4C9368335320C7218F55670A1D337DAF89F139EED635615A3BBB1CDAB967748A1EEC76D97B9A866BBB73341CDBB8423779745DB7BF9CDAA8EC4CF35CDBB50AE21A5E39FCE06CE1BE1EAB0F69A8B4C51A369D6571464A69B5E35FEE6ED51AB6A66A89473146B540EEE7B7FB0E76017FEB1839C8BB262B686570F69885CFF8239973EABB34A82C0A16AB1AD1312C43C0A498D2435EF8E5C78DCC66DA707F70F7FFCB838C919FCC7F11CB42D3DCED97682F95C7CA78BFFC12C20E865FFC3744EEDF8747A9771853361516FF2931719C80C0938D3234104FBE8ADF9F13974F9B202FEE015CEAED17ABA29882F9059AC11356F7AD81A2195CD04B71CDF7E394854C9503B4DA5738A8C63C94770AAD2EDA44B2B63FCE1271E6468534783026E9E33A2C0934B85BFDA93455183E6DBFB06B6965645C6D55405E52D1514A68E867FBE4EF5B49FECAF1D5C9CF78B453DE92584BB9C969D2D0B3D3E4AE6B042AF2463E3DF89F7913656ED2F99EC451B9F6C7E22A2617FFF788BFECB650175620AFF58833488028ECA256D42011EA31E4B2D1128E0334A61E72E09E2E5B542ECF2801369005FFFFE554AAE58F1D153BF6F7153F4E16EFE2D0E761A3A8B1A5F28FF29FC0E9ECC3F224168BBDB859F7EEEB8DBC2F9B8FF75ED2775F8047F268FD1ACD3482BA17D7920539629CDE27A6B71AD69C3FE0C708DF9DFFD990CAC903B1D768DF312754477DDD08F3FA24A0922B244310F099965F6CAF74757C017EB5BC79AA4DBB37382770B73267E26EDB5C38CAB0421A7A891542F5DA68BA2279FC9DDA3DC994740B8A79864303B031D9BB1088DBD3757F37DB26C94E995EFF11EBBE73B109CB4AD54D393CF449EB983F4D73D1CB860D97BCF7DC91CA80E5BE22DB5CD781233BDF9DC5B91FC5681B0CDC0449541D7BC321F900322613B5D58CB4D7C37050BDA6054C873361ED2F2E228FDFCB54664DEA30783A38ED8BAE05666850BFF05B29BF6AE245FAFEFC8E561D3C7A3F7E61985B4678DEEBFB217304503E48BCC5BB10991A8350CC3C97A175284074B8CEC433B5416269A9C063E910CEE2CFDD9B36B9DFAD7ABD7C45D857A352AD7F8F814090245D4BC5E14F720120987831DCF8C1E99DFC9B3A6D672F40837EEABBADB37FFB57AC9584E1A8E83341CB5B9ED4CC0B3C02E4E8533130F70EACB893BDDE8973B872BB03531B09614B33FEE224AC34ECD0138CBD0D9C1790BC1538B6BA71DBECDD6E507702A7DC306AAACFE629F9B9E9D982751DD96C8ACD905070AC3003E0AB0EBF6106F80F88C0D2F6B58BEC43D009E15FE8DD9B1F3B0581EE0262C7073B1DB353527DF3CF6AEFD3C123E3895E976F2EF4FD4A5AAA81BB63F507B87A72588EEC934588A57C90FA49B952541F4D9A3B1D2301E016409E251653F65F1AEF47ECA071D73E9AF4B130F3AC51C3CBF1896200423E0D454EBECE9C1C58185CB7931B57D15460174FEB181C6662BB2F9B35E11D98F5666EB3D4EBBCDD82D1ECD63A6375994133A178D00CE6DB44965B8AF272D95785ABA34CE3CBA863BDF796B9C77F7901D6EDA4A9365655683DE9946B984395CFDCF1A7457E3BC863E71A26B161661CBAEC69F7FBEE6769CB4111416424BCF6D8FCA914DB80B12C4D4C9B4CD45ABFF1DFFB377D5DC7B7F5E8278707A3910C6D2AB88FD7CDA30851793498C5160D1D7122617903A1FE25E4CDA5F1F32D0CDB0FD607D86D9C3E68E6C27DCEC88ED4CEE6F136F5453D9948257263CE11D6CD1B1DAEC7D14F923D753AAFE1E69EC0EAC2B2A425B8B6A9FFE0C701A82DD406C074D56EC301AB26CBD1879BB490EB0106B18DD1416A6566BF2196EB79B1C7905BAFAC08D565049BD3B88F10B1A9026820354BC8226E82E867FB29CC7AF229E7AF389799123B5F306186BC2D55FFDC26D65E0791C74C4B6B76C8AB4C113D78252F5E307536A4C1C3755A3FD05A56F6E1C2BC4CAE9C18FF00BE12CFCABA116BA32D104A4B5662AB40C4AB75099B191DCD662BCAD875C6777C74EDA597D5F62D28511C3430F199B7ABCDBCFCE9CE33F9BE9F9DB72ED2FD780505046AC08AE98C1B8C443183BE8825DB89112FF7A2A70FE63C748275EBDA660E72C9F92E01F4D959930A88955483D1741B256FE27A347FF47E1A93C77C4032F1F41D138E6D8DB7F13073EF106EA5E391162BC0E3AC19B09E771A79FF3A4911D042969979BAE3D9B1CC330816A26C0F20317334B426265FC9AAB99822DC4BB3F90D021D97DD92FB55E09F3C18A190962E5028C1215C09BC06C01AD45FAE6BA065A27598FB80EA868B9899785D23B4876270730962179B32934B14E32A5A808B4402A11620E9C30810EFE1D63E811B4F1F9F27AEE6A66D06C62175822D800901EF11B23D303D601CC64CC76BCFFCFE18EE20AE8398B84EAA5DE9A3732F7C98A543BD498BD679092FCC4720DFF8C2E42E7F77324644E9EBE5841C09E82E202814AC5266B41882DF3D5C4328DCA30FD99F081A8B865705E16F0AB67EB82288A37CB60CE7285680A1E5EE7A603BCF8E0E7BFA9B68EFB8E1BC710D936DF82B3C05C582B526835DB81FD2223B5FC280A5707234B20B73658CFBC7E01E3A1D0E027C483C07832C33294AC885126B7C5F1B906134EBA294D367CAC8604D1B65B707DB7C0D8EAF8D3CFBBBE0D4D50A7A35722E04BD01068D2865181BE03E37C6E62D46C265E8ECE0CB18E8F295C05EA5409EC3086D4D3F53D0B744588FBC1476AE96EA721674A1FD6BEF179B0FF8E6550F4E7069203B45FDAE526450F9A8E4979D51B5C4A887E8ED424F8C32705D835040ADBC9BA53EA2396831E73B56C3335F94B291F6B5FFC0D529353C1CB89452185BA78C8E3C2E7C01E5D85EFD6D6C5620E594A7281D6093325446FC808983D0A148C777C384732802E8F8BD5248874E1A987FB2BA15936194819816EB249A87C36198941B5DF7802F5B3D35E417E6DC66B32732EECBCD36B33043BB7C0CD22A9B78DA00F9BF33A676240268F99C8D830455611AF9B22198A0AA2ACA1D34B79363F692ACCE04CEB4ED565F946D0E14CF6FED5FECA97BF9E3AB0DEE3CD3B55EE5A19BC1B69000B1C231B92FEA1E937690243AC617222C98E20D3BA8C6F15A104795DE7C06D2BC2754861BC40294ED37710FD17D19EA457BDA79778146D6788CD309B33F6F952FCC845B401B49E7E069874145A4099426B3DE2D6DE5A518C8079BBC98EC7491D2E7CB164100FE292A356FD95B72DD33E638EDC665386547E51D42A402997066C492D39FE7AD623149741E85ED41465105D9F13768E74A21498F5910B2391B24487DEBE950E949E9D854A1036C9C08C29B096A96E02A024AB8521804EA989BB780E34CF28D340FB2A2437A136B1DB891BB4DCFDEAFF8486EF1EE9E302B6C874A2C70A513C1C1BD32E410C07B63604B3A85F6EB68FC98B7218EB88C7A07CD0A43D4003C4665AF7B7A51713CC3B97676FC12AF47083498078952041B407ACEF997711FA345966142A1D7DFFEEFDC799CF90AB786D84F066B3A12B884A27A108B1565BF1905979D94AD494CEB0C3625DC1B38AAC7994A1343F95C7140F7E03950E1031D3C31E36FFDC3BE87B6AD33F5E8A8BF69415397197B136B87F29ABC9194868EB6763360DA0DD6F0AF21D89DEA0CECA415069CAF7C8DB2753332F2003B2BA27BF20EA50C3FB3B0D0E49F8EE34CF77939B4F77E4B22488CF918BFB2113F9FA2AA233E4C0E32818CE22A012FE78CA6CFBC7977115A3C4ED43B531430B5C85B06E0C73AB7B5132EB528EBFD7367F9F8BEBFA6BE94347EA181F45D51204BFE5CFF8A2A3A81663037B42734FC51FB835DEF162C350B2FA02EE96D840540E6FA0C3C603D1056E6D4B62D9A18551E4DE5CB7414E8AF61942360B490FB9F8F08137425BFFEC7877347D0DD1A3565A9D72A040DE09D220B9A60F76186206FBBB0AA1BE9926F293CD98CD7D982DAED253377D9C0BA4C30C441C227EDD9EFAFC8DD0EDC853E4D115E983DB52E71D43417BD867AE6C817C97F681C854B4DDF3F0C13C5A8A74CB82FAAD6B67A585777822B617F0A692B6132EA1D40861D6EAE1BE9BA56739B88D6171F16B17F67EF9A6432B1B239399AAD58C4D9FE14B62561D4ACD16271FC6444E3779FF083F3418202F1E3218AB7FA2B2793B20E6D3D9A70B4A6E60533789C65AAC3D4247FA7F4D549573FEC21AD3B1BC52AE562439D45A13D61D88A2AF9AC2AE21DE7C21EE272B8BB5E1C3D00DA99654B1DE802D528B680A44A6A0F73EA78717A2AFF0C929011BB84F263A5C80E247C4F53EA968761BF511965788078E71D3863BA745422B933320AE4DE4E02E7A84590DE5B30B9DA124F0353B60DB27F435013DCD699CCD49517AF2EE15E186ECF09274B7953B36267B1B6B9A96EAF065C9408E0E1033F32B7F459BD41D6B9E5E8D59FF9968000C4355D1742342465852EDA51086195451A60793ED29C5530623D035563FE125DE6663C74BCBE19ECC7D3B74EF8C4F32FF769BA60496873AF9D7B744CABB9D2B87348F4181467999F815CC5C4BECE2ABC28D83F3FAC723A2A47633C4862045BBB603BD1F95B69C557B91B1BA70C4C3CFD3E97ACCF0228C80A3C025582B709105564C57AC1C0FAB3B4A4443D1208A87CBC45E14851223F8D6AA444FE00C690B7411ECF7E9FDDEF30D38952A6DB45BB30532A2465ED431A13C703B600770BD59B04AE3408BDD4DCACCBF7868247AC60CB256FF2C4500D4179AE0C06B60A945BC1AA4CDE8F399ABA04861C7B34A0259AC89D7CF5CEB1CE41CED02706E35497171CD2F3A2FBF14B32334F814A895F9B013DE70176A9CA71D1665302FD2901052A07B8B0F59F0471DDA24089D26677E84AEA09AB6E8893F99DDB14C8E37B98795650954224FDDC3A9139223151E2907A8DD30C36C4E1DB4C7E5FFA0DB484D5210EAB3AB2080CA378A390061F9348349CC6E085F3E460864C79662760E6806003AD4EA10A7710A7A349C7DFC3BEC122950B9E992DF861350D23BDCC2B5EE6A9BFAB24624885618DB3C09DD5010D68D054F1416EC6AAC3B4D3D259C20D3E993A78854F290045175FAE5683EEE35CB56269AB335C265FD5FDB0FEA61EFFE53B5F9E25C8939736E5E7CDF68D5B79B62A628ECE57E2DC4097BE489657212260D41FFEFCD63FF1DAB044C23A27535416A1EDAA9ABA0135E9E266C862D744D48539868A0BF53A53D8312DB8CA535CFDD9DA8EC463F48ED340F457C7FC0589D26412CA6D6423781DDFCFA368EEC54A1DA6014FD768013A0904E74AE2462877230EB08B4BD90B9C0B4C7AED95078F60250122CB0BFCBE328C90195EFE8A27A81E2910BC9EAC89FF37F3F227FAFC63C94DA84C9A9A37154E92A1817215923A85BC6F6202697BF1BBF261C6F38CF549E22998BF2A499978647CED365896721B30748FEACD12186337447EC3C28DE88D29CA2A9C19E4561330A54E2093E566737C46CBD03455CD4E8327CF00B3602D205F6496049A726F4BD29B4EC671EB2D3D9A41D252B2D50484857E09D893A06ED2E25ECDE0B8813791F4C04A424508568C767AAAA143AE0F4097EED859A2221212DD2A0C9A5C9AB54DC9E1FE27222FE472637D8F471B5FC01E738774761B94517C61ADEFF1A72E3399FE8B009F51D4AAB9E3E90531652A80DFCE9BB009AA7D536DFF4EB859D8BA19B6E068D7E9DDBDE0A9CC9FEBDFC35D327BF966CD7D85893C05E245F9320666EC1D9898BC7412FD4AB7A694E2AE189B683BF605CCC8AC1CF44A16AF6CD10E670EC7887A7520719015F2BDE565BA30C51DBAE22D3025B37745D7A9DC1DB9AD5CD46ADB58B54833DC07D629DBFA16C60EA6003886C456913E54124458C201E4E3CD663DB2CE30F88994294DC76CC7A29F83150E6E9980D218C5DF8146323A88A8F54A0E911B09DEFBA848A3A2EDF441E2072B11A942058B24046808D143FDDCBA6240875920941974F898F98C198122C8E021DB502EA3A6965D813E569E237741A974AC4D6AF28079313BFE8AEFC25AFAF52E06CBE5853079A15F0ADB02C945293EB53E21110C7A6A7929164FEE970830E6A0523A992B879F07080FDA05D410C6BBC9D61E02FD3F69B91F012BA2B1BCF651B1B7E2EF74856EA1DE1F42FFFEE172B7E8CA5CF281487076C802244347EB7E2ECC275A9E0E0D37E1E07589882223808306EA6AB92409F6C5FC76F3327608B3C687C3109BA01EE664B930D1DE890CA1BAA26E94FA1E4D056C5523E452563B4C22508ED05EC6AF898537DD60FB0A3B1788221375445B9051F08CC6D096E2DB400D1E15AD726345A2508C536F4CEFDA82F5C39F10E3FA2FF2BF023F5063F8EDC5268039D13EA37A908B96BA6863C9EE143972B277DCD1A8B7F2E6F7B55EDCDC618836E94DA66145BCA1BBBBC76FEBA18D1A81FFEB1497DE5A83B1DA2B28CD78131F1BAFCDF104B10C3662619AFFB540E3E0E308D73ED90A6C308DBC4B72F87CC47ED79E608FC626CBCFBD862CD9903ECD2FC8ABAFCD0BEAEDD0E4B37AECBF0B1E9D2A94DE42A5843F402B6AE24DA427705D8E1FAF64213A8330EE00AE493F85511A64CC0ACF9792E604C2982713D396847FE0704ECE0844ABE0094166E1F45650841A73F7B5EEFBC19938A590BBB0031EDA1D362E5896CC2B5B6E1B2A504B47BF077CE264AF2349A400E620E735B9C3A6AAB43DEE192868253C87CB7F4DB9BBDDE00DDBFB2761151B47A92367CA80763191A603E8076A8F86A96540C1F00DD12A6677F256CCA628CC90F96F6940ED9DA689C9D0864FBEE13AFF32FBECFA058C8E95BC6056DD9F7CAA57F46BE7F97EE8DA90C6095B9F96361C64AD04B99DF4A62ED6FFD049BC5487F075E3095F937D146804A8E61D6B925FE62E8868757C287FD95F8746A9495F6422B7D273223B00DABBFC05585F23BDE6F04D3A19A6C2155EAFFF83A5DCBE12C1A921828C07F96203AB9AA263D0B389570D2F65E6C488112BF93021FCF0E8D7D90CE8F88E928C4F632B4260DBE0C6D22CC1BC5918CA79C34E4EEDFA8FBD6A53F6A7C2BD97D9E3B3C747880B43ED37E84FFB13E826781CF1ADB2C7AFC0D2A1D1ECB9B0C045DF7F49AE5FA51BC7BBD2C3AF9B53437FC5AE961F196A6113ABFE954C2D711F5BF0F481032A4C107640D621CD8C99F65E1280C33F0001DC8C501CDBFA8F49FC3D5543E5719F6EEAF9DB9C98EB5EB68E48F46DF6E50804D480611BA3E2741C50707E1803BFBEEC8C98447D2CBB9DB26C5DE73231EF1DF5135D6994DD1600C5F359D8F53147FE41A5B6D9B97763CA211E8CDC6C9BB974E885158203104A559A32EE424FB6EAB447BA80D2D3035E0DD4E1D6EB7CDE560BD5F17086581BC3F9858A9139A9E12CE6A8B3F7155607785364E4A80BAE89115C999180D1EA0F2A89AFEB5C9778B213F3F48463A756FFE29298D6DD037E4CF52603C98EF92CD26C901637A2E268407C1896DE982F27A724F81A11045854F17877B1BAB43D870EB2CA2A110A70DA13A86CDE8A0C9E1FEA80205AF9E2887A1A393A49DF53D44F7F18AD4D25C578210A39DDEBD4D8200F20C83CC5C5B392B67437A5CF95BA2E86BCF1498FB00C8163A2AACCE97C114E50AFBCBC4BDC353849BACF1566325BC0AF4048B0A67688108A430640388BED2F6BED7179B0E9F393598CEE066CED48963E1991F0A9D2788CE20931A35ABEE0978B4626C805976D0209957E4642EAD1EFA63A14EF51432DFAABF96A60FFB036E6D34F9CC70F68EE4A152A9E08C092B5E3C032F076D413B0BDCD5DCE64E8D725B66356037A8E02A710340ED60AA48D9A100D7817AADBBD8C9FA70AAB74957542288933903354BCFAEB79FD37A70F55DFE12F0F12D0FAF0C7D3F8983CD228A72FC7F16533F633445C568CB3113E8353F5219B266310C0154EB14C720AC41FC2C4240970F1DAE2E1ADE3214CD34FA29568202F975916AEEC5C81435BBA6B1ADE0BE42ED485D42B758C3FCD49A0D3B6FB8A59123271846D04DAFB71005209F067E31A3016E0B4D076DC1C7411EB68D2346E12D244728B79888B93E246D98909B0421D82FC0AF653496D0F4A1AB5AA0BBCFD717975A33B2C2A1E7B1A1E4421E21370BA30FBB83319D3855D738008903DC28F0EE95BD2895AF3F19FA50645915455A9E8243317ACC847C1FA80C7C256497C745412FC2A9FC24202609B1FD895E1321E5EE255FA9F7962E125EBB1530E793597A247D289B1F930E2BAD5841256DE26D0DAFFB0201EE0833A44AE924A4580D19FA9E2BDA0A05B3115D3C3719F6CF0BD7785CA8784956F9AE984EC480F2CD42143233D0A7B7C9EEC98D5CEC44261F6584340CADAF5B7FCD34768C2AA577A5A7329507CEDFDF8278BDDD4E7A7096A997C67F732408FA6F6DABB2082B6E846576FD37C6CCC9AC4470769FB41A32D5BEC20E50F7CA7E1835548B57214CB1F1464DC740BFC5D0FE17355443729B8A20B7175628829523A72F9EA4B2ADF8380A7EEDC38725C39A1D8518D03CB36DBFA11BB597FA65C40DC4521872B0494F53F8E273B2EE044316A8CDAA0F260857F672BCD20FA49AF6DB1D77B86B2AFBE2F01AD71F074A104F1E2CEE083B47E94A8E78839A788B8D8A7F1C5C6CF4DB29B1BF2CF4D4FFED3B73FFCFA1679C088FC3B81FE1E3B3D40059109705CB5C2B27184FE1123B7DB7D5F3A5FB69B43038804C366C0F50183A07AAA6961092E613B5B84016E14EC81C14D90E3E7FA3E3FBA9D0B7319F3052067D0037226FE3D78AD7C347DEF4FDB2CB27AF22EC6617DABCE9ABBA5CF2FAE62CE4365FFE70F2DCE7EDF2671186C9EA3DD8F72D6B2196D4BFD4213BAC5CDBEB7CF1A912C4C546CE9A90E5980C8C5A48E10EF018D4F8240CC927AB12A307A3904882A67F9F2D193A1098CF4EB6BAE99D85D523847818129C6C95E70EFB3A1C1D77A465E257934371C3D5DD7C2A85B15DEA7D976EC11BF8A84C9A0AF19AC0CABA156B20DE1C16B06908BDA33864CCB9A729A2728261D3C330229AD3580CD3DF0B1FD610CC7695B4EC78C705F2F6B49FB70472A7EB41079E1BBCBE81DE7613B59A502E41F08C66D331EB20A41BA85A2675145E0C6B481FDC47D0653B89EF0AADAEB168AAE340C75D50898557B3DDF480CBAE132BDD850379FFFC482343AE9789A7ADD378FF7C625EC6EA79F0A8C37BBBF9C1C9359169640D6CF04D4EA62E57CD6C70A19837AB043B1AA0D834431650D1FA8ECAA743D5E87D3455348661BEC3EF522D793AF45B7E87F5955D0F9C6929D8FAE014C61A42674B8021C401682D015AD96C93963ACC0E409CBBB277826407E5F3F7814399232D63460351F864457E743E3B40B73EB4E6B56056D3B650FDA027BBEAE5BBF6D7E47E38777442A14CDCE9C0D80EEEAFE8C0A762D5A29E4B10AA522E5B625F8B13A0568F41D61D0C14B0147F09ED58DACE6B9669335E378476E15395CDD9BBF30FF21F4C75A034E02DB2628D37B97EA7D2DFF96C0AE2DB21BF740BBDB3306B893880923223F5030A82EA54B0445A3551E460ECBF60E9D499653BA3D069D269204150D14E6817513330DE665DECB62E1BA5048D5CBA2AED8C3EDBD0C74CF44C720AFED012C875CC9426571E3DBD3EBC8C10D9E14D56B0163BE38927C1DC4C624C296C0E30E3EDAA0C05C1A952BD18E5A1E867E8DD560D6E57F81FD6783AA49E1A3305726F7752CADF86A75E3EE3BD9BCF853663DB71A9634E90D48E2649DD25515BE01C8B4D15EF96A2A1A6BB0491F462929F236E058E508555A833529AEB05A61D5206601BB3EAF715AD13B27562532048D08DCADCE8DB6C3FE2B71CCA05BC7DA31B904D0C5D581E20B3A8B718BA5220CDF6CA673929DC9EE72A73FD7D09541F6029A5B6B977C7606D7A6624EB3701CFBE125E683E843A55E8BEE1ED6DCF8DB9EF4981FB16483AA4F7F83518CD294D28B1E518F1A0B847DC25ED28D727D1A7C121A1353B734754C933F2A53FF8CF4C35D2464223EB27712854F6B9C6A1A23F17F77EC77536B8C15A57DBF086F041E07A194F2A6E3454AC0B38B0398650241BAB427208E1EAD68C12089AEC3CE39C9290C25DB907004E32DA115809004F83F2296793A42CF4ADDEE0EB154257D59D2D47ECAD477485F8A4A6E00A289D7DDDA022952843471A05F80E07A014428783CA4AE1CDD0231E0A41F41924EAF2E21458C182208AF49CD053D097755B69402EC4EAC8149EE343DD28F9FAB42717D8AA2C6F51BAD89C90EB23B52534F59F180453749F78021C1104CFAC127864DAB0493600B7BDB119DB19C83680A00BB6CEAB02012174836142A0F8823684B2A60B8D7595C8D51DDF27EBC82F69EDC804633BA85F20417C09663FF8FB0CC491AA6EE524A354E77152B7AA453283EE4F28F2E222D9CFAA1E0CA2F7A1CF2CCB06E8023FE8256E3C8711A116908FD4FC13207FB685C0E9B3665E62EAB32E82869DC3BA2DFE1E6CAC2C5153803386C2BA05CA2875DB70A41641D88E9135E848E885C8AD1E7CBE0181DC4E53EB7783027964CDFA8C0BA32637C6761BAB65299A90903EA226F146825B872FAE755687D43D5C35D429BAC6161BF6DBD29203D4A17A3E5E7372792909BEC9471A13F2DDC0E47861A41A21A66DCC38A4C9C23A3E7A5689F00EA54D5B53A3F6168CA880370D8EACF75F603EA8FF3D3C04DF9C5F6DE5B14812956E10D1603B00DBCA4562E4097E6D9302A426B9AD1388CB9D9101779E04E9F10B77882E5BB0DAB5DC782670BF5340D323BA340C30F9F6A9B0E5074BD76866C67DC2AB60208DE821CA61EC24083B0254C1AD04071E8D328C5280D7F561F9267DB09FE0B580FA25F7047452A86FD71C66FDA5AB869C3C9127415088A78BEE4B9D7960FB09486FFF86D45F656074893BAF7FCAD8585409C70990C61FCAA6C88A511C15D81AA583BE02388875FC99EC026BF6D8466952CFB286318D0284DB2D0A6B0037ADB6AC5ACF2FBB03D5D6318CEE8EE4F16A68235836C3387F3104A84FB1A5520A2DB20591F1D8601781C8EF10447D31C9D4B024E2C00BDB2822FA13787364723E8A65CE3EE792DD8ED90E4475CF1D60A8EEBDE06B37F5FDB5B8413455A46F6C26CA6498402B9D9A500C3E975F914C529EA069936CE0F3BD4DE7F8279E8632D7458FFA09031E81AB1DD126424F756961B2151B019C147474D55794745D2F5C00333086409B736DADE083E095C862F186A8DC14741E6AE7A62C3B4CCF0A69A9D24EE1C28F8C67A802988A67840F52E2A1B5257600D0D0199092153D13D936023BD03F98514A0EA2EDF8B43584AE261D5BA5471A917AAE825BE7E6B1B724889A9876FF9833003591614940EDABED43C70866A9187D28065CDDDD6170AA444055FB895D4B0C16584E340C259C033E03B3940BD2C58CD97735098DDF305A5467B2EDDD3B4E16B6CE2D8BA44118113867E6B6CA83C12C64628C04A18C64930DDA850BFDC4430DF876FB9042AC2CA4DFE4B815CA661B6BEE25BAFD750F62B55532D43197821C8FAD339861D28EE44E0DF9911F14C592A76F02BBDBF1B26875A10FFA2FB4FE45013515AB8DF604ED975828559381213E33DE74E87CEF790C12D8181EBA2EB598B9E8006FD2406DD5931AADED202ACD58CDC491FEEA6E7D75ECD5FD244BE2110922E111E1651427AD8EABCCD09970AAAACB0D0569FBA01B420B7ACA4C25D75D804DF2D54DB52B16CC1A41285760122307450B6A80801AB4BEE02D31E05410F5FDEFF3DC97580F72F0AC0E712F486BC322209A208B5242B8D96130946CEB1F78A2B6A736B5D67F97041116AA33B7ED99094ECA7ACAE40BE8F6AF46DA1BAC2F295DBE5BBED70D63123C3A05ED8E8EECFE34E1FC3B6D73F9FFEEBF08151E128F413145442F69A0D4E4B1AD0E342921ADB08C4D80EBAF964F4E7D0E0B2F9B1ADEB7ECDCDA57F13D7050672789B3C53030829DBCD7046D37D482940D3B3135E7DFF562B4E0FA12EFC3F739FD9A1FA928DE652632056D887AB4785D993BD2E0751C2AB892FFFE61895F48EB3D46CA935B18E74FD80BC8C43C3A6CBA7A95C0C80E0E0D055DDDC0CAC918A76D0FC7ACFA4856844EB6F1EEC1A8B8101432275FAC8ED30C5FE6A434A93BB9A3D2D0C67D726993A96B894B67440944754157B4223118BC29A4A65B2DACCCAE0A1BDB95E83D08AB97238D201AFFF2AB86A55B0B99714DBB81B936A927BE1D7431A5088807522FF4CEBCCAF8C927BB6C2E4226FE229FC3255EFBCC9D68082A13CEAA1AC5723A3D041EA316ECF0352001ACCF80F70B9BED85BE9935FA442C3D9C810431F52F206A0BC33C84C9DF0104762959BD7F79C434CBC8615113D0B95B1516B0F3357417ACE60A822A84335881DC10FB3B687DBB86A3C578AE1BDFD9D6DE9B3031A64969230399E43687DF5424B9CDEADB8D46DDF7CAED2766C3B6C405AF70FAA6709DDF14DA30EAA278F11AC2D1D0C153F50CF420D1BC98102E8849243AF238EA84868813AC427580D99E7915A94610EEED3DBBA3A3A7DBBEBEF4B9D45292A123814108E8DD31C3C46E82E6A23AF02B55B0C60E6518CE30066729510B6094937341D65D90DCBAFC4213EAEE1876C8825DABC2372287B74DF16F7E1070D4270CB069E8BF0AB5A525C0548A263C9C7ECD161B27EC44F5F70571D4E513DC792CDF6D90DC245E105FB8A90DD37FE1BF1183ADA783819F2E822A0C52133E5C0FA032ADD1272AC32488B555F05910DAD8DF8EB11918C10FC2E79EBCA9976E067D1FB80AF4C009D884A6E3E7F13ABA6FF70F1F6AC621C5ED34655BBCFE244A33B2966C4CE8146CA30A32B1EC5061A40154EEEFEAC3F4D4DD03A2E2616CE9D4CBAA662625BAD9B06D0C0572B2DC1279E4B57BCF46DCE072C68ABA163F6875631421FCCAA69F4EBA54225EC84D61EC1AB26B6F8438426E2A430EC0E40BBC9AA1F02287CC79F728996A233569CF293491C6758710737A88684FE46A43D59F916A3625FF949578566117B742274B0242AF4DC68E532FD97A6E1DE1BFF904EF8E1498E155A1CE13D0E131E3FC96D8D9CC0B3E42705FC3EC6D1E1090B46EC717289B15A07436FD07E4FE639BC2F09DF66F1D6EE4EF93A2ADED08626AB1F85DE1BF7F5948D9B60011FD4103D14C7E271E480DCDA3A7FCF8642936FC89D5B2FB52CB349C6228A66ED40C295CFF20EE5C5F277B8B2985A5DE58B3E9CE3FB5C502F217373E2E036D259C558492D0AE959378F54B68B90AE86572B5DF31A694FF02D4E775359F6E8A4E387AA35A2DF9B321A2439BF15C7A08F7262E1E80423508F403E25128438C0017686C25941ED12CD238AC845FD744DA4CBE2C45D71B16134F67047BD0384CF38BA939CB00CB205D0DF93D4FDFD043A140E057279F9C5843950DF55D4A896E3677ADD589F51C4AB393791656D7E0FBE74AA8EFB141FB0D77CF1E4DA9AA1D6D2B5A73AB28D2EBC92D8B3FC6522B2A41F852FFD7373A104FFE3B64245FFE072E80689B789C632F49CCD6F30A706718052312ECB2676050B285B0173E34BCCBC0C4C00000FE2A064110FEDD15010000000100000025000000223D000001000000000000000000000000000000

Tks!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-07-18 : 16:30:24

You can use the ADODB.Stream object.

N 56°04'39.26"
E 12°55'05.63"

lisandro_cm
Starting Member

3 Posts

Posted - 2011-07-18 : 16:46:21

I've tried the following code, it creates the file but it's not readable. Not a real .jpg. The point it's not how to do it, but how to convert that binary data from that field into a readable .jpg image file. Tks

declare @archivo as varbinary(max)
set @archivo = (Select arquivo from assinaturausuario where cdusuario = 3)

DECLARE @ObjectToken INT
EXEC sp_OACreate 'ADODB.Stream', @ObjectToken OUTPUT
EXEC sp_OASetProperty @ObjectToken, 'Type', 1
EXEC sp_OAMethod @ObjectToken, 'Open'
EXEC sp_OAMethod @ObjectToken, 'Write', NULL,@archivo
EXEC sp_OAMethod @ObjectToken, 'SaveToFile', NULL, 'd:\Temp\test.jpg', 2
EXEC sp_OAMethod @ObjectToken, 'Close'
EXEC sp_OADestroy @ObjectToken

lisandro_cm
Starting Member

3 Posts

Posted - 2011-07-19 : 17:00:58

Found the solution, the data is compressed as zlib stream, no problem to display it with zlib.inflate.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources