Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
|
|
72 KB
|
|
78 KB
Hi Harish,
In SqlServer, CLOB is represented by the varchar and nvarchar data types. See this article: http://www.sqlines.com/oracle/datatypes/clob.
This link provides more documentation on data types in SqlServer: https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql?view=sql-server-ver15
Please enable the Save Content to File and Load Content From File options for varchar and nvarchar. Also there seems to be more specialized CLOB data types in SqlServer, for example: text, ntext, xml. So if it does not take to much effort, please also enable the same for these 3 additional data types.
Hi Nhi,
I enabled these options for varchar, nvarchar, text and ntext datatypes for SQL Server. Also, enabled these options for XML datatype. The XML datatype is also available in DB2LUW, hence checking for column type XML will fix it for both.
Revision no. 57651
Author: harish.khattri
Hi Nhi,
I enabled these options for varchar, nvarchar, text and ntext datatypes for SQL Server. Also, enabled these options for XML datatype. The XML datatype is also available in DB2LUW, hence checking for column type XML will fix it for both.
Revision no. 57651
Author: harish.khattri
Issue #15786 |
| Verified |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 20.6.0-rc-2 |
| No time estimate |
1 issue link |
relates to #10563
Issue #10563Ability to edit BLOB/CLOB data in Table Editor |
Hi Harish,
In SqlServer, CLOB is represented by the varchar and nvarchar data types. See this article: http://www.sqlines.com/oracle/datatypes/clob.
This link provides more documentation on data types in SqlServer: https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql?view=sql-server-ver15
Please enable the Save Content to File and Load Content From File options for varchar and nvarchar. Also there seems to be more specialized CLOB data types in SqlServer, for example: text, ntext, xml. So if it does not take to much effort, please also enable the same for these 3 additional data types.