Text truncation from Postgres Varchar(XXXX) to 4096 Char

Support
1

Dear EasyMorph Team,

I have a question regarding the reading of a varchar(128000) column from a PostgreSQL database. After executing the query, I notice that the text is truncated to 4096 characters for all strings exceeding this length.How can I prevent this truncation?

Should I perform a cast in PostgreSQL within my query, and if so, which cast would you recommend?

Alternatively, should I modify the DataType.Xml configuration, and if yes, how should it be configured?

Thank you in advance for your assistance.

Best regards,
Samuel

2

Hello Samuel,

At first glance, the PostgreSQL driver, used internally by EasyMorph, truncates very long strings. Therefore, the cast won't help.

We'll look into the issue more deeply and get back to you in a few days.

3

Hello Samuel,

Checked this more thoroughly on our test database, and it looks like everything works correctly for me. I was able to import a value 128000 characters long from varchar, text, and xml columns.

Which connector are you using to connect to PostgreSQL - native or ODBC?
What are your EasyMorph and PostgreSQL versions?
Have you tried running a query to check the actual lengths of values in the column? Like SELECT LENGTH(col_name) FROM ...

4

Hi Andrew,

It’s the native postgres driver. No odbc involved.

I’m going to check our postgres another time. I’ve checked in psql that length and type where genuinely varchar 128000, with length above 4096 for some values. I’ll get back to you with samples.

Thanks

5

Easymorph and EMserver at the latest versions build 17 /build 13.

Waiting eagerly 6.0 !!! We are definitely stucked in feb’ :grin:

1 Like
6

There’s so many new and improved features in version 6, I’m struggling to keep the “What’s new” blog post and video to a sensible length :smiley: