[DBAL-1233] TEXT type in MSSQL should be NVARCHAR(MAX) not VARCHAR(MAX) Created: 19/May/15 Updated: 26/Jun/15 Resolved: 26/Jun/15
|Component/s:||Platforms, Schema Managers|
|Reporter:||Javad Rahimi||Assignee:||Benjamin Eberlei|
|Labels:||mssql, nvarchar(max), schema, text, validator|
If a field type is defined as "TEXT" by generating the schema in MSSQL Server it generates a field type as "VARCHAR(MAX)". There will be no problem unless some UTF8 characters be inserted to DB; they all will be saved as "?????". If the field type be changed to "NVARCHAR(MAX)" there will be no problem and UTF8 characters will saved properly.
This fixed the main issue but after I generate the schema, whenever I validate my schema, it returns false on DB level.
Appreciate it in advance.
|Comment by Javad Rahimi [ 26/Jun/15 ]|
A temporary solution might be to change the function as:
It will fix the partially but as you know NTEXT will omit lots of functionalities on different SELECT queries and it's going to be deprecated by Microsoft.
I hope someone could find a better solution for this issue.