0
I need to change the data type of a field that is in "ntext" to "text". The reason is that I’m having trouble pulling this value from the database and generating a PDF with the php DOMPDF component.
When trying to change command line:
ALTER TABLE MyTable ALTER COLUMN mycolumn text
get the following error:
[Err] 42000 - [SQL Server]Cannot change mycolumn column for text data type
Is there any other way to change the data type of a table? Or force?
What kind of problem occurs? // You have tried retrieving column content using conversion to
nvarchar(max)
and only after passing to the DOMPDF class? // Have you tested whether the same problem does not occur when the data type istext
?– José Diz
With the type "text" I have no problems, also I did not think about converting the nvarchar(max).
– David Vinicius