Skip to Content

JDBC(JNDI) connectivity, varchar(max) field truncated to 255

Apr 10 at 11:39 PM


avatar image
Former Member

I'm connecting to SQL server 2016 through JDBC .( I tested this in CR2016 and CR 2011, with jdbc drivers 6.0, 6.2 ,6.4)
When I try to insert a varchar(max) field my data is truncated to 255 characters.... Right click in the Fields Explore/ Database Fields/Show Field Type shows that the field is String(255) but it is varchar(max) in my database...

Any ideas how to display all text?

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers