79122774

Date: 2024-10-24 16:05:13
Score: 1.5
Natty:
Report link

An example with SUBSTRING :

SELECT SUBSTRING(Data,1,1000000) part1, SUBSTRING(Data,1000001,1000000) part2, SUBSTRING(Data,2000001,1000000) part3, SUBSTRING(Data,3000001,1000000) part4, SUBSTRING(Data,4000001,1000000) part5, SUBSTRING(Data,5000001,1000000) part6, SUBSTRING(Data,6000001,1000000) part7 FROM MyTable WHERE ID=123

Copy and paste the 7 columns one after the other in a text editor by removing the 0x at the beginning of each column. Then we can do a HEX -> ASCII conversion (for example with Notepad+++)

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Bibi