Skip navigation

Log in to create and rate content, and to follow, bookmark, and share content with other members.

AnsweredAssumed Answered

ntext from SQL view, ArcMap read it as blob instead Text

Question asked by dllamasgmtgis-esridist

on Jun 16, 2017
Latest reply on Jun 16, 2017 by bixb0012

Like • Show 0 Likes0
Comment • 1

Hello,

In my SQL server database I have a field called observaciones_hechos(ntext,null).

in SQL appear as text

I am creating a view from this database table in ArcMap and for some reason instead seeing the text in the table of content I just see blob

How can I see the text instead blob in the view? Can I do that?

Thanks,

Diego Llamas

No one else has this question

Outcomes

1 Reply

bixb0012 Jun 16, 2017 7:52 PM
Mark Correct
Correct Answer
ntext is a legacy data type that has been deprecated: ntext, text, and image (Transact-SQL) | Microsoft Docs
Fixed and variable-length data types for storing large non-Unicode and Unicode character and binary data. Unicode data uses the UNICODE UCS-2 character set.
IMPORTANT!ntext, text, and image data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max)instead.
ntext isn't listed as supported in ArcGIS: SQL Server data types supported in ArcGIS—Help | ArcGIS Desktop

Looking back through documentation, it appears ntext hasn't been supported since ArcGIS 9.2 or 9.3.1.
1 person found this helpful
Like • Show 0 Likes0
Actions

Recommended Content