We changed the data type from sting to memo which causes a data corruption so the Arabic characters appear as question marks (??????).
How can we retrieve the original data in select statement with original contents before corruption note that we do not have a DB backup.
We try Select convert(nchar,text) and we got nothing
If your AX Database "Recovery Models" option is set to "Bulk logged" or "Full" I think you can retrieve the data from the ldf files.
Try to have a look at www.wikihow.com/Analyze-SQL-Server-Log-Transaction-(LDF-File)-and-Recover-Corrupt-SQL-Data-with-SysTools-SQL-Log-Analyzer
Thanks & Regards
Respect the provided answers from other community members. Don't provide or do not copy the same answer to the same thread. Additional insights are welcome!