Saving long string to sql server text column

General discussion forum about all databases other than SqlBase.
greg
Germany
Posts: 28
Joined: 01 Nov 2017, 12:50
Location: Germany

Saving long string to sql server text column

Post by greg » 02 Jan 2017, 08:26

Hi,

I want to insert/update a gupta long string (> 40000 Bytes) to a sql-server text-column. Unfortunately TD truncates it always to 32767 bytes. I already tried the longbuffer-Keyword in sql.ini, SqlSetLongBindDatatype in code - nothing helps. Any ideas?

Regards,

Gregor

greg
Germany
Posts: 28
Joined: 01 Nov 2017, 12:50
Location: Germany

Re: Saving long string to sql server text column

Post by greg » 02 Jan 2017, 10:19

Solved: using SqlSetParameterAll with DBP_LONGBUFFER worked.

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 3 guests