I have a table column contains VARBINARY (data like 0x…) [Column name is LDATA]
I just want to be simple to be understood.
The software puts in LDATA column a ZIP/RAR contains one XML file.
To reach the XML file, i need do those in order:
- Convert varbinary to base64 in SQL Server
- Use that base64 code to get the ZIP/RAR file (using online decoders)
- Extract the XML out of ZIP/RAR (using WinRar)
- Then read (Using Notepad++ etc)
I just want to read the XML file using only SQL Server (Using C# etc is NOT an option).
Is it possible?
Thanks in advance.