Is there a way to specify nvarchar(max) as datatype for a field using the MSSQL_ADO writer? ntext is deprecated so I can't use it anymore.
Solved
Using nvarchar(max) as data type with MSSQL_ADO writer?
+1- Contributor
Best answer by kjetilpettersso
I got the official answer. This is not supported (yet).
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Safer
Hi @kjetilpettersso,
As an alternative, the JDBC-based writers (MSSQL_JDBC_NONSPATIAL) have the ability to be set to nvarchar_max.
Hope this helps!
- Andrea