Board index » delphi » Truncating blob to 32K in SQL server 6.5

Truncating blob to 32K in SQL server 6.5

Hi,

I noticed something very strange when copying data from a table to
another.  If the table is on an SQL server 6.5, all blob fields (text and
image) seems to be truncated to 32 K length.  I tried to change the
corresponding parameter in the bde configuration application but this
doesn't seems to have a relevant effect,; instead it gives an error
message.
Does anybody exeperienced this problem already?

We have Delphi 3.0 with BDE realease 4.5.1 with MSSQL server 6.5 pack 4
and NT server Pack 3.0.  We use the native BDE driver MSSQL.

Francis

 

Re:Truncating blob to 32K in SQL server 6.5


We had the same problem.  I haven't had a chance to talk to the developer
who found the problem but I am pretty sure that you also have to change the
parameter in your TDatabase component.  There is a setting for BLOB size.
If that doesn't work, let me know and I will ask the programmer who fixed it
here..

-Adam

Re:Truncating blob to 32K in SQL server 6.5


This is part of the BDE setting.

Look at blob size in BDE settings for you database.  By default this is 32k.

Quote
Adam Rogers wrote in message <6hfhlp$i...@forums.borland.com>...
>We had the same problem.  I haven't had a chance to talk to the developer
>who found the problem but I am pretty sure that you also have to change the
>parameter in your TDatabase component.  There is a setting for BLOB size.
>If that doesn't work, let me know and I will ask the programmer who fixed
it
>here..

>-Adam

Re:Truncating blob to 32K in SQL server 6.5


You are correct in regards to the need to make the change within the BDE
Admin AND in the TDatabase component. Try that and see if it doesn't
work.

Other Threads