How to Convert Nvarchar(Max) to BLOB IN SQL SERVER?

1.4k Views Asked by At

How to convert Nvarchar(Max) to BLOB?

A SQLServer view have been using in Oracle through Databaselink. One of the text column datatype is NVARCHAR(MAX) and when I checked the max Lenght of Text column is 52000 characters. If I use NVARCHAR(MAX) causing issues in Oracle while accessing the view and when I tried to change to NVARCHAR(60000) its popping up error as invalid data lenght. How to solve this issue?

0

There are 0 best solutions below