distal-attribute
distal-attribute
distal-attribute
distal-attribute

Wrong generated select query, for colum of type XML (Microsoft SQL Server connector)

User, date Message
Written by paolo.sanchi
2 weeks ago
Category: General
8 posts since Thu, 04 Jul 13
Hi,
I'm connecting to a MS SQL Server, and I a table with some column of type XML (the content is textual, but big).
When I click the "Data" tab, the generated select query part for the column looks like this:
...
LEFT(CAST("column1" AS NVARCHAR(256)), 256),
..

If the content of the cell is more than 256 the cast fails, and I get the error:
"Target string size is too small to represent the XML instance".
If I replace the first 256 with max, like this, the query works:
LEFT(CAST("column1" AS NVARCHAR(max)), 256),

if you need more details, please, reply :)
Written by paolo.sanchi
2 weeks ago
8 posts since Thu, 04 Jul 13
sorry, I found the issue tracker just right now.. I will open an issue
 

Please login to leave a reply, or register at first.