Text fields : value truncated if > 2048 lenght

[loicdesguin]

Hello,

Using Pgloader to transfer data from a MSSQL source to a postgresql destination, I'm facing a truncation of the data transfered from a field nvarchar(2147483647) in MSSQL to a text field (Definition of the field are done by the application using the database)

All the value exceeding a length of 2048 are truncated to this size.

With an update / direct insert of the value, the destination column is well storing the data, so it looks like it's not a field size limitation in the destination.

I tried set a parameter "text size = 10000000000000" in the section [source] of the /etc/freetds/freetds.conf file but no impact.

Do you have an idea of the origin of this limitation and where increase it ? Thanks

Loïc

[JoshukLite]

I have faced the same issue. Is there any workaround?

[loicdesguin]

I solved the problem with the parameter : text size =

in the [source] section of the file freetds.conf

Regards

Loïc

[JoshukLite]

Okay, I see, thanks. Is this somewhere in the documentation?

[patrickklaeren]

if anyone has the solution to this I'm struggling with it also.