У меня есть база от android приложения. Есть столбец с BLOB
Там хранится текст (описание болезни). Но как его декодировать? Вот пример экспорта строки:
('1', '1', '2', 'Абсцесс', 'абсцесс', X'1F8B0800000000000400EDBD07601C499625262F6DCA7B7F4AF54AD7E074A10880601324D8904010ECC188CDE692EC1D69472329AB2A81CA6556655D661640CCED9DBCF7DE7BEFBDF7DE7BEFBDF7BA3B9D4E27F7DFFF3F5C6664016CF6CE4ADAC99E2180AAC81F3F7E7C1F3F221EAF8EFEA53FE95FFA9BFFE53FF85FFE23FEA5BF9DFEFD83D3FFE40FFA53D37FE9EFFC97FEA67FE96FFE97FE817FE9EFFD97FEF67FE96FA1DFFFFE7FE9EFFA97FEF651FA2FFFE1FFD2DFF42FFF41F4F7DFF32FFF21D4FC0FA24FFFCE7FF90FFD97FF847FF98FA67678FD4F4CA9F93FF02FFFC1FFD23F488DFEDE7FE9EF42B37FE9EFFD97FFB87FE9EFFF97FFD87FE9EF4BFFA57F90DEF9074C5704FFEF4BA9C5DFC31DFCEDFFD2DF9D52F7FFD2DF4ABFFF03FFD2DF6DDEF8070839F4F877D26F16937FE9EF1BA7FFD29F479FFC1D04E90F49F10681A3DEFEE53F2E65707F0F75C508FE2DF4E91FC9B0FEEE1EF68C2B0106C8BF877BFD5B0834FDF52FFF8923E0C560FE2E6A45BFFF0318AC85B4C5FDFDBD8CC0DF2FEFFC4B7F7BCAD8FDADF42B351A01017CF5B7FC4B7F1F354383BF0B40B97FFAEC0E0D20A0FBBFFCC7A6DCF26F257AD288FEE67FF98F95D1FC8382D6BFFC0711F63C4C42864943986DF1B77F1B21CF88C8A77718E7BF95A8FE87F214FE3DD4B534A6D162C87F3F7A203C803606FB87A73CBABF95D1FF9BFEE53F9C50FFFBA8F73F8A3AE5F152033349FFF29FF82FFFE177C68FEFAE8E1ECFF78EFEA5BFF05FFA8BFEA53FEB5FFA2BE9FF7FFEBFF4D73EBE4B1F819DFECC18EF84B4FE9B64DAFE9694D12016028F80E29818193318E86F93B799AB7C2489EBC0397F24CF30BDAF54E23FFE0E7A8B4746D4F8DB531AEA1F4950FF601EC0DF05DE9029233A831878EDEF014B02519A1ECC2980FF5D7883470EFEE3B1FC03E88E19026DD27FE96FA319F9430145200D70BDF91A6FFF4DC01E93FC77699F7FB3703A40FEFDFFF21F06E8C40CC427C41A7FA1B21BF31218CBE3947FE96F7AC433B02E8F1E97C551975A4C6B27567F57CAA3FF9BA883BF8B39F6EFE1FFE3DFBF4546F83707F2FC77FB7475FC0A2C84787FD7E1E3BBD42DBAC69718350BF51FAC8D3D79E88C0B64F8439C60422AFE26A64B402AA63D134C79C55309316AABC43AAC00565FB1980472627B92997412F177793C665B19FEF807983330BB7FE24D3D8261FF1EC3445EB3BF8F9BFC1D3C8D7F882A1BE153FA037FFE6DEE7DD0EE8FB1B4FB07A425A60B23FE7BA0C804888806BDF9F7F39030F1F4F3EF00CCBF4F3BFA07C682C25D700CE4F62F2689FDF3487AFF927FE92FA09F4E72FFF28E7657DCFE369AA03FB1C784901668967F103D08831043B1E2F913493AFE449A6A96271A959A88BFABABCFFFBE809185E7789274C6FE1651433A892C557F9FB20F690A82FA0751AF5B84DF3F90EEEF109B3060F406D3F2B7DCF1288F5EFF687AE94F149C5841F1F4FC715E230833240473FDF7B078FF1D7DEEA2F7818E7E235AFF1F64A4FE1016FCBFA9D36BCF767598512615B2FA0F1242A4083D2348C365A5F40F88883162D06F7F5368718D16FB9B1837C50BAF42DE448B9BD1FECB7F025B075669344D6A44C0FADDF93553D0353D2A16182D04F0CE489C05310F50587F4B17BDBF5D5E604260C678187F9F5A561A3D53833FE151FFCB7F62975DFF3462D73FE95FFA53C9C8FC05C4BA7F09FDF5E7FC4B7F9265DABF92F98FEC25943DAB3A4612869F063CB2FEC0DFCB94501F2118EB0888807C7FE43661F37761E6A106E05660EE8C9682C9A2EF88B9C5D2B3AA97B9E5C1FC5D4C3766786FBEFF6EA6238F5E784667DC691A6A8B5966F6FFDBD44889C78196A1AE173E66A81E0A4E4985CA99BA23407F2B77FB0F8878C00CB082FF838DA0C5D1FEDB3D364643C839718F510C224A2CF801645F29FE7DAA14FF2E619B6D956F56FB84D81F7C2B28C6355039FA5BE86F365DB7C5FD1FA417FE7E51A2E045E530AF4168FD4401FCADB7A4519751FFDC7FE94F276FE84F2746FDB3FEA53FDD32E89FCB8CE7A98B508D12B8BF87C6F827581E237682FC51B33F31D48F1E6F76118497F9B793AE64078A292616E61F80DB8766CC4C7F8860E09BD3BF3BD03D50E27F1724F66F1797456C3135F0756960AAD83E08AB2987FFDD5ED3BF8919F0EF2222FF5DCCD3B0E71E8B1A3711E6F75F628DA47602CA8781FE836291423BAAB8FE71C42B321150E870ABFE3663B136BCACF6E36F67C9D1990467442488CDDBDFC70C24CAEFEFE2BF80A68AA7CF0034D3ECB5F56618D27E83D7CD2A04AA1BF22D0A117DB3EB239E0E9B1655387F93E16651E3D677728EF95F40C6FD4F225D6934E65F6799F14F171F57DC71F198FF3E80FAFB616037EA4F18F71B74E81FCBB6EAEF81AEFFBBC074AAF40596A0DC8F9BFEEE80C91F67E9BCCECF3FFBE8DDF62C6BB34777EF96D5342B1FECDDFB88358ACCC3BFFC873CBE9B1DB9991A78EB606FE7234C3847228CD42DDFDBFDF423C3287F17B3E6DFDF7F177344D8FC61A18209E634D0A13D7790280197FD6F313E2CBB38CCB07F387DE0F3219B7180107EF883C0F081F7F9B72BFBC2631753DC11C4D013676F121AF90FF997E039207236DA8403803F0AB3E8BDFD778A20F94E8F1597AE0EFC532926FC4B89FD8801530E0FFFE2C05AFF29ECA611CDD867B29C0256E7E013BC0FF982EB109A3E88DEDF614322E1548244FE617A7F47CCFB1FE2E14C1A1533C49655AC87F19B98D02C973C2CCD3340E2E016FEED4C94BFAF0F89FD3213D7FE9D8885D97D1AA604A2E3BFE05FFACB88047F2E09E39FD3735CFE3471AB257A92E84C4CD1DF2553DD3314D067983E31EBA4F2247C16F38C9921D717F8F76847AFB3C13402AF4AE81FC0A83116E18EBF8B795883611171846CEAC3FECDA248ED778214938DD31DDC487EF382C680DB11F10A311504ACEE1FCE1CF5F7FCCB7FA868987F9009ACBA01E41195F3B7235816C7E9EF327325B65CF481655FB4B049268E05FEA08D38706320CBE467BE106167DEE0A095A5EEEFE2FF83F2E19806E81A284A3F5A05649711FBDBA39936A49F6C946C924EBEDD7646CEE6D238E364023E6D60920E18432712DF1AD07C9FEE4263FE3D3A7882069D07D8839AF2BED394FF9238F26CF2455BFECB7FEC1D4F2AFE1FC09A4A9C6C140000', NULL),
