Big data being chopped off

[Rahul Sharma]

Hi,

I am using activerecord-sqlserver-adapter and trying to read from a table that has a column of type VARCHAR(MAX). This column contains some XML. When I read this xml using activerecord, the result being returned is not the full XML but some of it is cut off. Is there a way to fix it? Is there some sort of limit on the size?

Thanks,

Rahul

[Ken Collins]

SQL Server truncates large text columns by default. You can configure this with the SET TEXTSIZE. Since custom settings are so common, especially with TEXTSIZE, it is included in the README here under the how to configure your connection section.

https://github.com/rails-sqlserver/activerecord-sqlserver-adapter#configure-connection--app-name


- HTH,
Ken