Forum Discussion

Joao_Carlos_Miguel's avatar
Joao_Carlos_Miguel
Copper Contributor
Apr 18, 2024

Recovering wordpad RTF content stored in ntext format

Hello,

I have a large database which was created by a third party software on SQL server. I can access the content but when I try to read a specific column, the data, which is formatted for Wordpad, is stored in ntext. I need to migrate the content to a different database and I don't mind much about the text formatting. However, there are a number of entries with images as well and I cannot access them. Is there a way to recover this data?

1 Reply

  • olafhelper's avatar
    olafhelper
    Bronze Contributor

     


    which is formatted for Wordpad, is stored in ntext. 

    Joao_Carlos_Miguel , WordPad is an application, not a file format. So which format is it, .DOC, .RTF or ...?

    And keep in mind:

    1. The data type NTEXT is deprecated since a long time, don't use it

    2. The data type NTEXT stores text, not binaries like images. If it, then it is somehow encoded in a way we don't know. Contact the software vendor support/developer to get more informations.l

Resources