Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Text fields : value truncated if > 2048 lenght #1620

Open
loicdesguin opened this issue Nov 4, 2024 · 0 comments
Open

Text fields : value truncated if > 2048 lenght #1620

loicdesguin opened this issue Nov 4, 2024 · 0 comments

Comments

@loicdesguin
Copy link

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.

image

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

Loïc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant